データベース毎にバックアップファイルを分けるPostgres バックアップスクリプト version 1.1 http://sonic64.com/2003-04-17.html # Get all DB name TARGET_DB=`psql -l -P format=unaligned -P fieldsep=, -P tuples_only |perl -F, -lane "if (@F[0] ne …

ERROR: duplicate key value violates unique constraint "pg_largeobject_metadata_oid_index" DETAIL: Key (oid)=(xxxxx) already exists. ALTER LARGE OBJECT In one of my odoo database, I ran this SQL query in PGAdmin III to delete the largeobjec…

EFS File System Size (GiB) Baseline Aggregate Throughput (MiB/s) Burst Aggregate Throughput (MiB/s) Maximum Burst Duration (Min/Day) % of Time File System Can Burst (Per Day) 10 0.5 100 7.2 0.5%http://docs.aws.amazon.com/efs/latest/ug/perf…

https://ma.ttias.be/enable-keepalive-connections-in-nginx-upstream-proxy-configurations/ 前提条件として Nginx > 1.1.4 が必要。http://qiita.com/toritori0318/items/a85d0b1efbd3ea1fc950 http://blog.nomadscafe.jp/2012/02/nginx-11x-httpupstream…