PostgreSQL Links

1. General
2. PostgreSQL on Windows
3. Other Supported Platforms
4. Documentation and Books
5. Tutorials
6. News
7. Online Articles
8. Enyclopedia Articles
9. Comparisons with other databases
10. Mailing Lists and Forums
11. DBA Tools
12. Replication
13. Applications
14. Interfaces
15. Extensions
16. Migration
17. Development
18. Link collections

General

Main PostgreSQL site

http://www.postgresql.org/

pgFoundry - repository of PostgreSQL related projects

http://pgfoundry.org/

PostgreSQL on Windows

Running & Installing PostgreSQL On Native Win32 FAQ

http://pginstaller.projects.postgresql.org/FAQ_windows.html

PostgreSQL Windows binary installer

http://pgfoundry.org/projects/pginstaller

Installing PostgreSQL on Windows Using Cygwin FAQ

http://www.postgresql.org/docs/faqs.FAQ_CYGWIN.html

Compiling PostgreSQL On Native Win32 FAQ

http://www.postgresql.org/docs/faqs.FAQ_MINGW.html

"PostgreSQL Software Installation"; with guide to installation on MS Windows using Cygwin

http://www.databasejournal.com/features/postgresql/article.php/3064861

Other Supported Platforms

Debian packages for woody from Oliver Elphick

http://people.debian.org/~elphick/

Backports for sarge from Martin Pitt

http://people.debian.org/~mpitt/packages/sarge-backports/

RPM Packages for SUSE

ftp://ftp.suse.com/pub/projects/postgresql/

"Installing PostgreSQL on Red Hat / Fedora Core": PDF guide from Devrim Gündüz

http://pgfoundry.org/docman/?group_id=1000048

PostgreSQL on Mac OS X: Article from Apple

http://developer.apple.com/internet/opensource/postgres.html

PostgreSQL packages for Mac OS X including 10.2 and 10.3

http://www.entropy.ch/software/macosx/postgresql/

PostgreSQL Tools for MacOS X

http://sourceforge.net/projects/pgsqlformac/

Documentation and Books

Online documentation sources

http://www.postgresql.org/docs/

Docs for current PostgreSQL version

http://www.postgresql.org/docs/current/static/

FAQs

http://www.postgresql.org/docs/faq/

Techdocs - a collection of articles and tutorials

http://techdocs.postgresql.org/

Search-engine for PostgreSQL-related documentation from the makers of Tsearch V2

http://www.pgsql.ru/

"Practical PostgreSQL" - online version of the O'Reilly Book

http://www.commandprompt.com/ppbook/

"PostgreSQL: Introduction and Concepts" - online version of Bruce Momjian's book

http://www.postgresql.org/docs/books/awbook.html

Tutorials

PostgreSQL 101 (from the Association Electronique Libre)

http://wiki.ael.be/index.php/PostgresQL101

Richard Huxton: "PostgreSQL Notes" - useful recipies for various PostgreSQL features

http://www.archonet.com/pgdocs/pgnotes.html

David Pashley: "PostgreSQL User Administration" - an introduction to PostgreSQL users and groups

http://www.davidpashley.com/articles/postgresql-user-administration.html

News

The front page of the main PostgreSQL site carries the latest news

http://www.postgresql.org/

The mailing list pgsql-announce carries announcements about PostgreSQL and related products, including the regular newsletter "PostgreSQL Weekly News"

http://archives.postgresql.org/pgsql-announce/

Overview of press releases related to PostgreSQL, from Sean Chittenden (with RDF feed)

http://sean.chittenden.org/postgresql/news.html

Online Articles

Database Journal: PostgreSQL section

http://www.databasejournal.com/features/postgresql/

"How PostgreSQL Rose to Fame": Article by Bruce Momjian

http://www.oreillynet.com/pub/a/network/2000/06/16/magazine/postgresql_history.html

"PostgreSQL Performance Tuning": Article by Bruce Momjian

http://www.linuxjournal.com/article.php?sid=4791

"PostgreSQL's Multi-Version Concurrency Control (MVCC)": Article by Joseph Mitchell

http://www.onlamp.com/pub/a/onlamp/2001/05/25/postgresql_mvcc.html

Enyclopedia Articles

FOLDOC: PostgreSQL

http://wombat.doc.ic.ac.uk/foldoc/foldoc.cgi?query=postgresql

hyperdictionary: POSTGRESQL

http://www.hyperdictionary.com/computing/postgresql

Wikipedia: PostgreSQL

http://en.wikipedia.org/wiki/PostgreSQL

Comparisons with other databases

Critical comparison as wiki from PhiloVivero

http://faemalia.org/wiki/view/Technical/PostgreSQLvsMySQL

REM Automatisierung: Performance comparision between PostgreSQL and a major commercial database

http://research.rem.nl/performance.html

Evil Magic: MySQL & Sequences (compares with PostgreSQL's sequence implementation)

http://www.evilmagic.net/archives/2004_02_28.html

Mailing Lists and Forums

Overview of active mailing lists

http://www.postgresql.org/community/lists/

Mailing list archives at PostgreSQL.org

http://archives.postgresql.org/

The Mail Archive (12-24 hours delay)

http://www.mail-archive.com/index.php?hunt=pgsql-

Mailing list archives at theaimsgroup.com (see section "Databases")

http://marc.theaimsgroup.com/

GMANE NewsPortal WebNewsReader: gmane.comp.db.postgresql.* archives

http://news.gmane.org/index.php?prefix=gmane.comp.db.postgresql

Usenet archives of the mailing lists (note: often out of sync with mailing lists)

http://groups.google.com/groups?q=comp.databases.postgresql&hl=en

"General Bits" by Elein provides a useful summary of discussions on the pgsql-general list

http://www.varlena.com/varlena/GeneralBits/

Dev Shed PostgreSQL forums

http://forums.devshed.com/f21/s.html

dBforums: PostgreSQL

http://dbforums.com/arch/81

Tek-Tips PostgreSQL Forum

http://www.tek-tips.com/threadminder.cfm?pid=699

DBA Tools

Techdocs: PostgreSQL GUI Design and Administration Tools (overview)

http://techdocs.postgresql.org/guides/GUITools

phpPgAdmin - Web Based PostgreSQL Administration Tool

http://phppgadmin.sourceforge.net/

pgAdmin III - excellent GUI tool for MS Windows, Linux and FreeBSD

http://www.pgadmin.org/

PostgreSQL Autodoc: generates database descriptions in HTML, Dot, Dia and DocBook XML formats

http://www.rbt.ca/autodoc/

Replication

Slony-I --- A replication system for PostgreSQL

http://gborg.postgresql.org/project/slony1/projdisplay.php

eRServer: single-master/multi-slave asynchronous replication system released under the Berkeley/BSD license

http://gborg.postgresql.org/project/erserver/projdisplay.php

Article: "Quick Outline of ErServer Internals" by Andrew Sullivan

http://www.varlena.com/varlena/GeneralBits/Tidbits/erserver_works.html

Applications

DBMail: works with an MTA to store email in PostgreSQL or MySQL

http://www.dbmail.org/

Movable Type: Blog / Weblog system with PostgreSQL support

http://www.movabletype.org/

Interfaces

DBI - database abstraction layer for Perl

http://dbi.perl.org/

The dbdpg Project: Perl DBI driver (DBD::Pg) for PostgreSQL

http://gborg.postgresql.org/project/dbdpg/projdisplay.php

PHP Manual: PostgreSQL functions

http://www.php.net/manual/en/ref.pgsql.php

Article: "PHP and PostgreSQL - A matter of choice"

http://www.devshed.com/Server_Side/PHP/PostgreSQL

Article: "Making the PostgreSQL and PHP Connection" (ONLamp.com / Joshua Drake)

http://www.onlamp.com/pub/a/onlamp/2002/01/24/postgresql.html

PostgreSQL JDBC Drivers (Java DataBase Connectivity)

http://jdbc.postgresql.org

PostgreSQL and JDBC FAQ

http://www.fankhausers.com/postgresql/jdbc/

psqlODBC - The PostgreSQL ODBC Driver

http://gborg.postgresql.org/project/psqlodbc/projdisplay.php

Extensions

PostGIS: "Geographic objects for PostgreSQL". Implementation of OpenGIS "Simple Features Specification for SQL", similar to Oracle's Spatial Extension.

http://postgis.refractions.net/

Tsearch2 - full text extension for PostgreSQL. Used by the search box on the left.

http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/

Pgbash: execute SQL as shell commands

http://www.psn.co.jp/PostgreSQL/pgbash/index-e.html

Migration

techdocs: List of article on conversion from various databases, including MySQL, MS-SQL, Microsoft Access and Oracle.

http://techdocs.postgresql.org/#convertfrom

Article: "Migrate your site from MySQL to PostgreSQL"

http://www.sitepoint.com/article/529

Migrate your site from MySQL to PostgreSQL: Article from sitepoint, written in 2001 but still largely valid

http://www.sitepoint.com/article/529

Development

The PostgreSQL Global Development Group

http://developer.postgresql.org/

Developers' FAQ

http://developer.postgresql.org/readtext.php?src/FAQ/FAQ_DEV.html+Developers-FAQ

TODO list

http://developer.postgresql.org/todo.php

CVS web interface

http://developer.postgresql.org/cvsweb.cgi/

Snapshot of the development documentation

http://developer.postgresql.org/docs/postgres/index.html

Link collections

dmoz.org / Open Directory Project - Computers: Software: Databases: PostgreSQL

http://dmoz.org/Computers/Software/Databases/PostgreSQL/

About.com: Postgres and Ingres Databases

http://databases.about.com/cs/postgresingres/