Community Generated Articles, Guides, and Documentation
From PostgreSQL wiki
Contents |
Major article and documentation topic subsections
- Detailed installation guides
- Converting from other Databases to PostgreSQL
- Database Administration and Maintenance
- Development with PostgreSQL
- 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 Shockwave tutorial on Sequences by Justin Clift
- A Shockwave tutorial on Referential Integrity by Justin Clift
Other Applications
- Community Guide to PostgreSQL GUI Tools
- 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 Notes by Richard Huxton
- 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 8.3 Cheat Sheet by Postgres OnLine (January/February 2008)
- PostgreSQL 8.3 TSearch Full-Text Search Cheat Sheet by Postgres OnLine (May/June 2008)
- PostgreSQL 9.0 Cheat Sheet by Postgres OnLine (September/October 2010)
- PostGIS related study guides Regina Obe and Leo Hsu
Troubleshooting
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)
