Articles

Authentication

• PostgreSQL and pam_ldap by Adrian Nida
• NSS Authentication with libnss_pgsql by David Ford
• Authenticating PostgreSQL Clients by SecurityProNews (2002-05-21)

Development

• Programming OTL using PostgreSQL and unixODBC in the Solaris environment: a step-by-step guide by Carlos Crosetti (2006-02-13)
• Programming OTL using PostgreSQL and ODBC in the Windows environment: a step-by-step guide by Carlos Croseetti (2006-02-13)
• Writing Applications for PostgreSQL by Bruce Momjian

Email Servers

• Qmail using PostgreSQL user authentication by Michael Devogelaere

Enterprise Related

• PostgreSQL for Enterprise Business Applications by Ron Chmara (2002-01-29)

Full Text Indexing

• HOW-TO: Full Text Indexing with PostgreSQL by Christopher Kings-Lynne (2002-04-07)

Introductory

• Overview of new features in PostgreSQL 7.4 by Josh Berkus and Joe Conway (2004-02)
• Introduction to PostgreSQL Rules - Making entries which can't be altered by Justin Clift (2001-07-20)
• Wikipedia related article: A good set of related definitions.
• The postmaster and postgres Processes by Charlton H. Lopez
  
  

JDBC/J2EE

• The PostgreSQL JDBC Primer by Joe Shevland
• Accessing PostgreSQL through JDBC via a Java SSL tunnel by Chianglin Ng

Materialized Views

• Implementing Materialized Views in PostgreSQL by Jonathan Gardner

Microsoft Access

• Connecting to PostgreSQL from Windows Platforms by Damond Walker
• Using a Microsoft Access AutoNumber Field in PostgreSQL by Frank Hilliard

Microsoft .NET

• The npgsql Project - .Net Data Provider for PostgreSQL
• Using Microsoft .NET with the PostgreSQL Database Server via ODBC by Matthew Stanfield (2002-04-15)

Migration

• Interview with Mark Stosberg (From Oracle/tcl to PostgreSQL/Perl) by Robert Treat (2004-10-24)
• Interview with Jim Wilson (From SQL Anyware & Foxbase) by Robert Treat (2004-06-13)

Optimising

• Annotated postgresql.conf (html) by Josh Berkus and Shridhar Daithankar (Recommended)
• Performance Tuning by Josh Berkus and Shridhar Daithankar (Recommended)
• How-To: Replacing Slow Loops in PostgreSQL by Joel Burton
• PostgreSQL Database Performance Tuning by Jean-Paul Argudo (Recommended)
• PostgreSQL Hardware Performance Tuning by Bruce Momjian (Recommended)
• Community Disk Tuning Guide
  
  

Other Applications

• Community Guide to PostgreSQL GUI Tools
  
  
• PostgreSQL and Crystal Reports HOWTO by Mike Godshall (2004-03-24)
• Using PostgreSQL for a Domino 6 RDBMS Backend (pdf) by Keith Perry
• Borland JBuilder + BEA Weblogic + PostgreSQL Howto (Chinease)
• Using Echelon SQL Scripter with PostgreSQL by Branden Williams and Matt Springfield
• PostgreSQL derived databases

PostgreSQL Usage

• PostgreSQL Notes by Richard Huxton
• A Brief Guide To NULLS 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)
• Updating columns in PostgreSQL tables effectively by Joel Burton (2001-04-23)
• Using Aggregate Functions and Operators in PostgreSQL Part 1 by Branden R. Williams
• Using Aggregate Functions and Operators in PostgreSQL Part 2 by Branden R. Williams
• Using Aggregate Functions and Operators in PostgreSQL Part 3 by Branden R. Williams

PL/pgSQL

• HOWTO Return more than one row of data from PL/pgSQL functions by Stephan Szabo

Recovery

• PostgreSQL table checker and dumper tool by Martijn van Oosterhout

Referential Integrity

• Compensating for Unimplemented Features in PostgreSQL 7.1 by John Pagakis and Todd Gauthier (2001-08-21)
• Referential Integrity Tutorial & Hacking the Referential Integrity tables by Joel Burton (2001-09-03)
• Removing Foreign Keys by Dan Langille

Regular Expressions

• Introduction to Regular Expressions in PostgreSQL by Will Trillich

Replication

• Don't be lazy, be consistent: Postgres-R, A new way to implement Database Replication by Bettina Kemme and Gustavo Alonso
• HOWTO: Setting up RServ with PostgreSQL 7.0.3 by S.Gopi (2001-09-13)
• Usogres Replication Test report by Dobrica Pavlinusic

Restoration

• Adventures in PostgreSQL, Episode 1 by Josh Berkus (2002-05)

Upgrading

• Tips for upgrading PostgreSQL from 6.5.3 to 7.0.3 by Mark Stosberg

Web development

• Using Macromedia UltraDev with PostgreSQL, Tomcat and Apache by Tony Grant

Other Languages

• Italian: Appunti di PostgreSQL by Giorgio Ponza - GlugCN (2006-03-14)