FirstDBA - PostgreSQL


 DBA's quick reference designed to share information to the most popular relational/object database management systems

                Oracle    PostgreSQL    MySQL    SQL Server     DB2     Firebird                                                Home

  •  Documentation: 

             > What's new in 8.1 | 8.2 | 8.3 | 8.4 | 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