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.