Community Generated Articles, Guides, and Documentation

Major article and documentation topic subsections

• Detailed installation guides
• Converting from other Databases to PostgreSQL
• Database Administration and Maintenance
• Development with PostgreSQL
• Performance Case Study
• PostgreSQL Performance Optimization
• Frequently Asked Questions
• Replication, Clustering, and Connection Pooling

Community Generated Articles

Introductory

• Introduction to PostgreSQL Rules - Making entries which can't be altered by Justin Clift (2001-07-20)
• A flash tutorial on Sequences by Justin Clift
• A flash tutorial on Referential Integrity by Justin Clift

Other Applications

• PostgreSQL ecosystem - a directory of software and cloud services that support or use PostgreSQL
• PostgreSQL Clients
• Community Guide to PostgreSQL GUI Tools
• Design Tools - GUI tools for ERD schema design
• Qmail using PostgreSQL user authentication by Michael Devogelaere
• HOWTO: PostgreSQL and Crystal Reports by Mike Godshall (2004-03-24)
• Using PostgreSQL for a Domino 6 RDBMS Backend (pdf) by Keith Perry
• Using Echelon SQL Scripter with PostgreSQL by Branden Williams and Matt Springfield
• PostgreSQL derived databases
• Using Open Office Base 2.3.1 with PostgreSQL Postgres OnLine Journal (January/February 2008)
• Using OOo Base to connect to PostgreSQL - OpenOffice.org Wiki

PostgreSQL Usage

• PostgreSQL Change data capture (CDC) + golang sample code.
• A Brief Real-world Trigger Example by Richard Huxton
• Retrieving Database meta-data from the Information Schema by Lorenzo Alberton (2006-05-02)
• PostgreSQL 101 by Shridhar Daithankar (2006-05-01)
• FAQ: Working with Dates and Times in PostgreSQL by Josh Berkus (2001-08-25)
• How to avoid overlapping intervals with PostgreSQL by Matteo Nastasi (2001-07-16)
• COPY by Jeff Eckermann (2001-09-17), rewritten (2008-03-02) Evan Carroll
• PostgreSQL 9.0 Cheat Sheet by Postgres OnLine (September/October 2010)
• PostgreSQL 8.3 TSearch Full-Text Search Cheat Sheet by Postgres OnLine (May/June 2008)
• PostGIS related study guides Regina Obe and Leo Hsu
• Don't Do This

Troubleshooting

• Operations cheat sheet
• Generating a stack trace of a PostgreSQL backend

Deprecated articles

These are articles that are not really applicable to current versions of PostgreSQL, but are kept here for those still running those old versions:

• Information on the 8.1.4/8.0.8/etc. Security Release
• Tips for upgrading PostgreSQL from 6.5.3 to 7.0.3 by Mark Stosberg
• Overview of new features in PostgreSQL 7.4 by Josh Berkus and Joe Conway (2004-02)
• Replication HOWTO: Setting up RServ with PostgreSQL 7.0.3 by S.Gopi (2001-09-13)
• Usogres Replication Test report by Dobrica Pavlinusic (2002-04-22)
• HOWTO : Full Text Indexing with PostgreSQL using contrib/fulltextindex by Christopher Kings-Lynne (2002-04-07)
• PostgreSQL for Enterprise Business Applications by Ron Chmara (2002-01-29)