-
Documentation:
> What's new in 8.1 | 8.2 | 8.3 | 8.4 Beta | Features Matrix
> Search PostgreSQL Documentation
> PostgreSQL Technical Articles
> Practical PostgreSQL Online E-Book
> PostgreSQL Administration
> PostgreSQL Database Maintenance Tips
> PostgreSQL Release Notes
> PostgreSQL TODO list
> PostgreSQL Conversion Documentation
> PostgreSQL Mailing List Archives
> Annotated Postgresql.conf Guide
> PostgreSQL in a Nutshell - a DBA perspective
> PostgreSQL Tips - a DBA perspective
> Slony-I in a Nutshell - Replication Solution for PostgreSQL
-
Scripts & Functions:
> PostgreSQL System Functions
> PostgreSQL Statistics Access Functions
> Slony-I Replication Scripts
-
Performance:
> PostgreSQL Performance Tips
> Influencing PostgreSQL Query Planner
> PostgreSQL Statistics Views
> PostgreSQL Resource Consumption Tips
> Postgresql Annotated Postgresql.conf Guide
> PostgreSQL Performance Checklist
> PostgreSQL Tuning SQL Statements Efficiently
> PostgreSQL Server Run-Time Configuration
> PostgreSQL Database Maintenance Tips
> PostgreSQL Server Error Reporting and Logging
> Performance Tuning PostgreSQL - Revsys
-
Distributions:
> Bizgres MPP - For Business Intelligence & DW
> EnterpriseDB - Oracle compatibility,PostGIS,Slony
> Mammoth - PostgrSQL+Relplicator - Replication
> ExtendDB - For Business Intellignece,Data Warehousing
-
Tools:
> pgAdmin III - Download (free)
> EMS SQL Studio - Download
> CASE Studio - Download
> Visual Case - Download
> pgFouine Log Analyzer - Download
> PQA - Practical Query Analysis - Download
> iSQL-Viewer - Open-source SQL tool (Postgres,MySQL,Oracle)
-
Advanced Topics:
> Slony-I - Asynchronous master-multi slave replication
> uni/cluster - Middleware high scalability Solution
> pgpool - Sync multi-master replication / connection pool
> pgcluster - Sync multi-master replication
> PostGIS - Spatial extention to PostgrSQL. GEOS
-
Certification:
> PostgreSQL Certified Engineer - CE
-
Training:
> Open Technolog Group
> The Modern Solution
> Free PostgreSQL for self-training (full version)
-
Useful Links:
> PostgreSQL Official Site
> PgFoundary - PostgreSQL Related Software
> PostgreSQL General Bits - Varlena,llc
> PGSearch - Search PostgreSQL Sites
> PostgrSQL - Red Hat Edition Project
> Power PostgreSQL (Berkus and Conway)
> Pervasive - PostgreSQL Directory
> pgAdmin PostgreSQL Tools
> Christopher Browne's Pages
> Bruce Momjian's Pages
> PostgreSQL Meetups on the Map
> PostgreSQL Anniversary Summit Conference