17th September 2020: PostgreSQL 13 RC 1 Released!

pg_live available for download

Posted on 2007-03-08

Pg_live is designed to introduce to both the general public and the experienced DBA to the possibilities of PostgreSQL. Originally created for OSCON 2004, pg_live development continues and is used today as a teaching aid and as a marketing tool for the community at conferences and tech-shows throughout the world.

Describing all of what pg_live contains would make for a very long and boring announcement. Therefore, I'll try to give as brief and as descriptive a breakdown of what it has.

The pg_live Live CD uses an xcfe GUI environment. It boots, by default, with three active services: a PHP enable Apache webserver, SSH and of course a running instance of PostgreSQL.

The PostgreSQL server has been precompiled with the following procedural languages: plpgsql, plperl, pltcl, plpython, plruby, pljava and plr.

SLONY replication, and connection pooling via pgpool is present.

As can be inferred by the procedural languages, pg_live also contains a number of programming environments with the relevant connectivity libraries permitting access into postgres i.e. R, tcl, python, perl and java (JDBC).

Three clients are present: psql, pgadmin3 and phppgadmin.

Finally, pg_live has thousands of pages of reference documentation, both in English and in French. These include the default postgres references as well as a number of diverse howto's.

Thanks to the kind support from the New York City BSD User Group (NYCBUG, which is pronounced "Nice-Bug") you can download pg_live at http://www.nycbug.org/index.php?NAV=Library;SUBM=10101

This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.