Robert Lor's Weblog

PostgreSQL 8.2.4 in Solaris Expres Developer Edition

Today Sun announced the availability of Solaris Express Developer Edition 5/07. There are many new features in this release and among them is the inclusion of PostgreSQL 8.2.4 with SMF and DTrace integration.

1) As root, su to postgres
# su - postgres

2) Create Postgres DB cluster
$ /usr/postgres/8.2/bin/initdb -D /var/postgres/8.2/data

3) As root, use the SMF's svadm command to start Postgres
# /usr/sbin/svcadm enable postgresql:version_82

Note that Postgres 8.1 is also available. The binaries are located in /usr/bin and /usr/postgres/8.2/bin for 8.1 & 8.2 respectively. To use 8.2, make sure to add /usr/postgres/8.2/bin in the PATH. For more info see postgres_82 man page (e.g. run "man postgres_82" from the command prompt).

With 8.2.4 all the user-level DTrace probes are now enabled. To see the list of available probes, run "dtrace -l | grep postgres"

For more info on how to use the probes, refer to http://www.postgresql.org/docs/8.2/static/dynamic-trace.html

Posted at 04:17PM Jun 12, 2007 by Robert Lor in PostgreSQL  |  Comments[1]