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)
- The postmaster and postgres Processes by Charlton H. Lopez
- 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 Prático by Ribamar FS
- 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)
- How to use PostgreSQL's COPY function effectively by Jeff Eckermann (2001-09-17)
- 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)
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)
