Online PostgreSQL Resources

I l @ ve RuBoard

There are a number of online resources that assist in the installation, administration, and development of PostgreSQL.

Web Sites

A full collection of mirrors can be found at www.postgresql.org. There are also a number of commercial support sites.

Mirror Sites

Australia

postgresql.planetmirror.com

Canada

www.ca.postgresql.org/index.html

Germany

postgresql.bnv-bamberg.de

Italy

www.postgresql.uli.it

Russia

postgresql.rinet.ru

United States

postgresql.readysetnet.com

Commercial Support Sites

Great Bridge (www.greatbridge.com/). Commercial products, services, and support for PostgreSQL.

PostgreSQL, Inc. (www.pgsql.com/). Support for PostgreSQL, database hosting, and promotional materials.

Software Research Associates (osb.sra.co.jp/). Open-source software support ” a range of services to help customers develop open -source software “based systems since April 1999.

Cybertec Geschwinde & Schvnig OEG (postpress.cybertec.at/) inVienna (Austria). Offers training courses, support, consulting, cost-effective high-end systems, and high-availability solutions in the whole German-speaking region (Austria, Germany, Switzerland).

dbExperts (www.dbexperts.com.br) in Brazil. Offers training courses, specialized support for development, and commercial products for PostgreSQL in the Portuguese language.

Applinet (www.applinet.nl/). Offers PostgreSQL consulting services in the Netherlands.

Command Prompt, Inc. (www.commandprompt.com/). Offers Linux-managed services and PostgreSQL support. Located in the Pacific Northwest, Command Prompt, Inc., specializes in Linux and PostgreSQL support, including custom programming featuring PostgreSQL, C++, PHP, and Perl.

Mailing Lists

The PostgreSQL user and development community has a very active set of mailing lists. The procedure for subscribing to any of the following lists is as follows :

1. Send a message to <groupname>[e-mail] (where <groupname> is the name of one of the following groups, such as [e-mail] ).

2. Put the word "subscribe" or "unsubscribe" in the body of the message.

3. Optionally, include the phrase "set digest" to consolidate multiple messages into one daily email instead of numerous individual emails.

4. Optionally, set the phrase "set nomail" in the message body. This will stop the flow of email but still keep you subscribed. (This is useful for the following newsgroup option.)

The following mailing lists are currently active:

• [e-mail]

  Covers the topic of PostgreSQL administration and related issues.

• [e-mail]

  Announcement group for third-party and related items.

• pgsql- bugs @postgresql.org

  Mailing list to report or check the status of a found bug.

• [e-mail]

  Group dealing with running PostgreSQL on Windows machines using cygwin .

• [e-mail]

  General discussion area. Does not cover installation, compile, or bugs. Generally, this is the most active list.

• [e-mail]

  Mailing list for developers or those interested in doing customizations to the PostgreSQL code base.

• [e-mail]

  List to discuss external APIs to the PostgreSQL back end. (Note: There are separate lists for the ODBC and JDBC interfaces.)

• [e-mail]

  Used to discuss the external JDBC Java interface.

• [e-mail]

  Used to discuss the external ODBC interface.

• [e-mail]

  Discusses using PostgreSQL and PHP.

• [e-mail]

  Discussion area for aspects of the SQL language.

Newsgroups

You can subscribe to many newsgroups from the PostgreSQL news server (news//news.postgresq.org). Although anyone can read these groups, you must be subscribed to one of the preceding mailing lists to post.

 comp.databases.postgresql.admin  comp.databases.postgresql.announce  comp.databases.postgresql.bugs  comp.databases.postgresql.committers  comp.databases.postgresql.docs  comp.databases.postgresql.general  comp.databases.postgresql.hackers  comp.databases.postgresql.hackers.fmgr  comp.databases.postgresql.hackers.oo  comp.databases.postgresql.hackers.smgr  comp.databases.postgresql.hackers.wal  comp.databases.postgresql.interfaces  comp.databases.postgresql.interfaces.jdbc  comp.databases.postgresql.interfaces.odbc  comp.databases.postgresql.interfaces.php  comp.databases.postgresql.mirrors  comp.databases.postgresql.novice  comp.databases.postgresql.patches  comp.databases.postgresql.ports  comp.databases.postgresql.ports.cygwin  comp.databases.postgresql.questions  comp.databases.postgresql.sql 

FTP Sites

The collection of mirrored FTP sites is the primary way to get source and binary packages that relate to PostgreSQL. The main web site, www.postgresql.org, lists a collection of addresses. Here are the more popular sites:

• Australia

  ftp.planetmirror.com/pub/postgresql

• Canada

  ftp.jack-of-all-trades.net/www.postgresql.org

  looking-glass.usask.ca/pub/postgresql

  postgresql.wavefire.com

• Germany

  ftp.leo.org/pub/comp/os/unix/database/postgresql

  ftp-stud.fht-esslingen.de/pub/Mirrors/ftp.postgresql.org

• Italy

  ftp.postgresql.uli.it

  postgresql.theomnistore.com/mirror/postgresql

  bo.mirror.garr.it/mirrors/postgres

• Japan

  ring.asahi-net.or.jp/pub/misc/db/postgresql

• Russia

  ftp.chg.ru/pub/databases/postgresql

  postgresql.rinet.ru

• United Kingdom

  postgresql.rmplc.co.uk/pub/postgresql

• United States

  postgresql.readysetnet.com/pub/postgresql

  download. sourceforge .net/pub/mirrors/postgresql

  ftp.digex.net/pub/packages/database/postgresql

  ftp.crimelabs.net/pub/postgresql

I l @ ve RuBoard