======Applications - Databases - PostgreSQL - Miscellaneous====== [[http://www.postgresql.org/|PostgreSQL]] \\ [[http://planet.postgresql.org/|Planet PostgreSQL]] \\ [[https://www.postgresql.org/support/versioning/|PostgreSQL - Versioning Policy]] how long each version will be supported. =====Documentation===== [[https://www.postgresql.org/docs/|PostgreSQL - Documentation]] [[https://www.postgresql.org/docs/current/|PostgreSQL - Documentation - PostgreSQL Current Version]] [[https://www.postgresql.org/docs/10/index.html|PostgreSQL - Documentation - PostgreSQL 10]] \\ [[https://www.postgresql.org/docs/10/datatype.html|PostgreSQL - Documentation - PostgreSQL 10 - Data Types]] [[https://www.postgresql.org/docs/10/static/dblink.html|PostgreSQL 10 - Appendix F. Additional Supplied Modules- dblink]] for connecting to other PostgreSQL servers from PostgreSQL. \\ [[https://www.postgresql.org/docs/10/static/postgres-fdw.html|PostgreSQL 10 - Appendix F. Additional Supplied Modules - postgres_fdw]] for connecting to other PostgreSQL servers from PostgreSQL. \\ [[https://wiki.postgresql.org/wiki/Disk_Usage|PostgreSQL Wiki - Disk Usage]] =====Blogs===== [[http://rhaas.blogspot.nl/|Robert Haas]] Senior Database Architect @ EnterpriseDB, PostgreSQL Major Contributor and Committer \\ [[http://momjian.us/main/blogs/pgblog/2012.html|Bruce Momjian Postgres Blog]] \\ [[https://amitkapila16.blogspot.com/|PostgreSQL and Databases in general]] a blog by Amit Kapila. \\ [[https://paquier.xyz/|Michael Paquier - PostgreSQL committer]] \\ =====Articles/Blogposts===== [[http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL|WikiVS - MySQL vs PostgreSQL]] (dead link) \\ [[http://www.pfz.nl/wiki/postgresql/|PFZ.nl - PostgreSQL]] (dead link) \\ [[http://www.bostongis.com/PrinterFriendly.aspx?content_name=sqlserver2008r2_oracle11gr2_postgis15_compare|Boston Geographic Information Systems - Compare SQL Server 2008 R2, Oracle 11G R2, PostgreSQL/PostGIS 1.5 Spatial Features]] \\ [[http://suckit.blog.hu/2009/09/29/postgresql_history|suck IT - PostgreSQL history]] overview of the performance ofPostgreSQL 8 t/m 8.4.1.\\ [[http://rhaas.blogspot.nl/2012/06/absurd-shared-memory-limits.html|Robert Haas - Absurd Shared Memory Limits]], see also [[http://lists.dragonflybsd.org/pipermail/kernel/2012-September/000004.html|SYSV shared memory vs mmap performance]] \\ [[http://rhaas.blogspot.nl/2012/03/why-is-my-database-corrupted.html|Robert Haas - Why Is My Database Corrupted?]] \\ [[http://rhaas.blogspot.nl/2012/03/tuning-sharedbuffers-and-walbuffers.html|Robert Haas - Tuning shared_buffers and wal_buffers]] \\ [[http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server|PostgreSQL wiki - Tuning Your PostgreSQL Server]] \\ [[http://momjian.us/main/writings/pgsql/hw_selection.pdf|Bruce Momjian - Database Hardware Selection Guidelines (PDF)]] \\ =====Tools===== [[https://github.com/omniti-labs/omnipitr|github - omniti-labs / omnipitr]] Advanced WAL File Management Tools for PostgreSQL \\ [[http://bucardo.org/wiki/Bucardo|Bucardo]] is an asynchronous PostgreSQL replication system, allowing for both multi-master and multi-slave operations. \\ [[http://bucardo.org/wiki/Check_postgres|check_postgres]] is a script for monitoring various attributes of your database. It is designed to work with Nagios, MRTG, or in standalone scripts. \\ [[http://www.repmgr.org/|repmgr]] is a set of open source tools that helps DBAs and System administrators manage a cluster of PostgreSQL databases. \\ ====Foreign Data Wrappers==== [[https://wiki.postgresql.org/wiki/Foreign_data_wrappers|PostgreSQL Wiki - Foreign Data Wrappers]] [[https://github.com/atris/JDBC_FDW|GitHub - atris/JDBC_FDW]] wraps JDBC for PostgreSQL.It can be used to connect and fetch data from any data source that supports JDBC. \\ [[https://github.com/EnterpriseDB/mysql_fdw|GitHub - EnterpriseDB/mysql_fdw]] foreign data wrapper for MySQL. \\