Table of Contents
Applications - Databases - PostgreSQL - Miscellaneous
PostgreSQL - Versioning Policy how long each version will be supported.
Documentation
PostgreSQL - Documentation - PostgreSQL Current Version
PostgreSQL - Documentation - PostgreSQL 10
PostgreSQL - Documentation - PostgreSQL 10 - Data Types
PostgreSQL 10 - Appendix F. Additional Supplied Modules- dblink for connecting to other PostgreSQL servers from PostgreSQL.
PostgreSQL 10 - Appendix F. Additional Supplied Modules - postgres_fdw for connecting to other PostgreSQL servers from PostgreSQL.
Blogs
Robert Haas Senior Database Architect @ EnterpriseDB, PostgreSQL Major Contributor and Committer
Bruce Momjian Postgres Blog
PostgreSQL and Databases in general a blog by Amit Kapila.
Michael Paquier - PostgreSQL committer
Articles/Blogposts
WikiVS - MySQL vs PostgreSQL (dead link)
PFZ.nl - PostgreSQL (dead link)
Boston Geographic Information Systems - Compare SQL Server 2008 R2, Oracle 11G R2, PostgreSQL/PostGIS 1.5 Spatial Features
suck IT - PostgreSQL history overview of the performance ofPostgreSQL 8 t/m 8.4.1.
Robert Haas - Absurd Shared Memory Limits, see also SYSV shared memory vs mmap performance
Robert Haas - Why Is My Database Corrupted?
Robert Haas - Tuning shared_buffers and wal_buffers
PostgreSQL wiki - Tuning Your PostgreSQL Server
Bruce Momjian - Database Hardware Selection Guidelines (PDF)
Tools
github - omniti-labs / omnipitr Advanced WAL File Management Tools for PostgreSQL
Bucardo is an asynchronous PostgreSQL replication system, allowing for both multi-master and multi-slave operations.
check_postgres is a script for monitoring various attributes of your database. It is designed to work with Nagios, MRTG, or in standalone scripts.
repmgr is a set of open source tools that helps DBAs and System administrators manage a cluster of PostgreSQL databases.
Foreign Data Wrappers
PostgreSQL Wiki - Foreign Data Wrappers
GitHub - atris/JDBC_FDW wraps JDBC for PostgreSQL.It can be used to connect and fetch data from any data source that supports JDBC.
GitHub - EnterpriseDB/mysql_fdw foreign data wrapper for MySQL.