PostgreSQL Administration

commands in psql:

\dx #show all installed extension
\l #list all databases
\password <username> # change password for user

https://medium.com/braintree-product-technology/postgresql-at-scale-database-schema-changes-without-downtime-20d3749ed680
https://gajus.medium.com/lessons-learned-scaling-postgresql-database-to-1-2bn-records-month-edc5449b3067
https://www.2ndquadrant.com/en/blog/pg-phriday-terrific-throughput-tracking/
https://blog.crunchydata.com/blog/managing-transaction-id-wraparound-in-postgresql
https://blog.crunchydata.com/blog/a-guide-to-building-an-active-active-postgresql-cluster
https://www.2ndquadrant.com/en/blog/banking-on-postgres-webinar/

高可用方案：
共享磁盤故障轉移
文件系統(塊設備)複製
預寫式日誌(WAL)傳送
邏輯複製
基於觸發器的主-備複製
基於語句的複製中間件
異步多主控機複製
同步多主控機複製
其他商業方案