By rnl on Jun 12, 2007
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.Here's how you'd run Postgres 8.2:
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