PostgreSQL source

Useful links all about PostgreSQL.

all versions history-> https://bucardo.org/postgres_all_versions.html

pgconfigurator -> http://pgconfigurator.cybertec.at/

 

https://www.brendangregg.com/perf.html

 

https://dbaclass.com/article/how-to-create-database-link-in-postgres/

https://dbsguru.com/steps-to-setup-database-link-in-postgresql/

 

https://www.waitingforcode.com/postgresql/alter-default-privileges-postgresql/read

 

https://www.crunchydata.com/blog/how-to-upgrade-postgresql-passwords-to-scram
https://www.thegeekstuff.com/2010/03/how-to-execute-postgresql-commands-inside-unix-shell-scripts/
https://blog.trackets.com/2013/08/19/postgresql-basics-by-example.html

https://www.howtoforge.com/tutorial/postgresql-replication-on-ubuntu-15-04/

https://www.postgresql.org/docs/9.5/static/storage-file-layout.html

https://www.postgresql.org/docs/8.1/static/app-pg-ctl.html

http://www.rassoc.com/gregr/weblog/2013/02/16/zero-to-postgresql-streaming-replication-in-10-mins/#comment-136674

http://www.nevprobusinesssolutions.com/how-to-set-up-master-slave-replication-on-postgresql/

https://docs.jelastic.com/postgresql-database-replication

https://edwardsamuel.wordpress.com/2016/04/28/set-up-postgresql-9-5-master-slave-replication-using-repmgr/

http://info.crunchydata.com/blog/easy-postgresql-cluster-recipe-using-docker-1.12

https://www.howtoforge.com/how-to-set-up-an-active-passive-postgresql-cluster-with-pacemaker-corosync-and-drbd-centos-5.5

https://www.howtoforge.com/how-to-set-up-a-postgresql-9.0-hot-standby-streaming-replication-server-with-repmgr-on-opensuse-11.4-p2

http://www.p2d2.cz/files/postgres-for-oracle-dbas.pdf

http://www.thegeekstuff.com/2009/04/15-practical-postgresql-database-adminstration-commands/

http://raghavt.blogspot.in/2011/04/postgresql-90-architecture.html

http://raghavt.blogspot.com/2011/10/replication-in-postgresql-90.html

http://raghavt.blogspot.com/2011/10/high-availability-clustering-with.html

http://dba.stackexchange.com/questions/9587/automating-failover-in-postgresql-9-1

https://access.redhat.com/sites/default/files/attachments/cloudforms_ha_master_v4.pdf

http://stackoverflow.com/questions/3004523/postgresql-database-default-location-on-linux

https://ask.fedoraproject.org/en/question/8847/just-installed-postgresql-what-path-is-it-stored/

https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling

https://www.postgresql.org/community/resources/
http://www.postgresql-archive.org/
https://www.reddit.com/r/PostgreSQL/comments/5nso64/what_are_the_best_postgres_forums/
https://stackoverflow.com/questions/32002846/run-psql-and-pg-dump-without-password-and-without-using-sudo-u-postgres
http://www.postgresql-archive.org/

http://suite.opengeo.org/docs/latest/dataadmin/pgGettingStarted/firstconnect.html
https://www.cybertec-postgresql.com/en/prepared-transactions/


PostgreSQL Memory Management
https://brandur.org/postgres-connections
https://pgtune.leopard.in.ua/#/
https://severalnines.com/blog/architecture-and-tuning-memory-postgresql-databases
https://www.postgresql.fastware.com/blog/back-to-basics-with-postgresql-memory-components


Postgres-XL

https://ruihaijiang.wordpress.com/2015/09/17/postgres-xl-installation-example-on-linux/

http://bonesmoses.org/2015/12/11/pg-phriday-postgres-xl-and-horizontal-scaling/

http://www.peterhe.com/database/postgresql_xl_installation_and_deployment_279/

http://developers-club.com/posts/261457/

http://blog.yuanxiaolong.cn/blog/2015/08/07/install-postgresql-xl/

https://sourceforge.net/p/postgres-xl/tickets/77/?limit=25

http://files.postgres-xl.org/documentation/index.html

http://files.postgres-xl.org/documentation/pgxc-ctl.html

http://files.postgres-xl.org/documentation/tutorial-createcluster.html

http://files.postgres-xl.org/documentation/server-start.html

Postgres Pro

https://postgrespro.com/docs
https://bluemedora.com/guide-to-installing-oracle-em-plugin-for-postgresql/