pg_dumpall > backup.outFor Ubuntu 14.04
sudo add-apt-repository "deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main"
Deepak Puthraya deepakputhraya
deepakputhraya
/ box_spare5.json
Last active
September 7, 2017 04:45
JSON structures: Annotating Bounding Boxes. Polygons and Cuboids by Spare5 and scaleapi
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "points": { | |
| "p6": [0.232, 0.26986507], | |
| "p7": [0.77066667, 0.26986507], | |
| "p8": [0.77066667, 0.46626687], | |
| "p9": [0.232, 0.46626687] | |
| }, | |
| "cv_objects": { | |
| "0EAF8033-9501-6BC2-9653-E40CE148D301": { | |
| "closed": true, |
deepakputhraya
/ Postresql Migrate from 9.4 to 9.6.md
Last active
March 4, 2017 08:34
Migrating from Postgreql from 9.4 to 9.6 with very simple commands. This technique will work if anyone wants to migrate to different versions. This requires down time
sidharthkuruvila
/ data_holder.js
Created
December 15, 2016 12:38
Migrate knex migrations to liquibase
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| exports.queries = []; | |
| exports.holder = []; |
rondy
/ Effective_Engineer.md
Last active
July 20, 2024 05:11
FWIW: I (@rondy) am not the creator of the content shared here, which is an excerpt from Edmond Lau's book. I simply copied and pasted it from another location and saved it as a personal note, before it gained popularity on news.ycombinator.com. Unfortunately, I cannot recall the exact origin of the original source, nor was I able to find the author's name, so I am can't provide the appropriate credits.
- By Edmond Lau
- Highly Recommended 👍
- http://www.theeffectiveengineer.com/
jarpy
/ requirements.txt
Last active
June 30, 2022 06:28
Serverless Elasticsearch Curator for AWS Lambda
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| certifi==2016.8.8 | |
| elasticsearch-curator==4.0.6 | |
| PyYAML==3.11 |
RobertoSchneiders
/ deploy_with_ebcli3_on_circleci.md
Last active
December 4, 2023 09:07
Settings to deploy to AWS Elastic Beanstalk on CircleCi (EB Cli 3)
This is how I configured the deploy of my rails apps to AWS Elastic Beanstalk through CircleCI 1.0.
If you are using the Circle CI 2.0, take a look at this article from ryansimms
On Project Settings > Environment Variables add this keys:
- AWS_ACCESS_KEY_ID
- AWS_SECRET_ACCESS_KEY
The aws user must have the right permissions. This can be hard, maybe, this can help you.
rgreenjr
/ postgres_queries_and_commands.sql
Last active
July 22, 2024 09:57
Useful PostgreSQL Queries and Commands
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |