svcadm disable postgresql svcadm disable mongrel/facts curl -O http://ftp7.us.postgresql.org/pub/postgresql//source/v8.3.3/postgresql-8.3.3.tar.gz gunzip postgresql-8.3.3.tar.gz tar -xvf postgresql-8.3.3.tar cd postgresql-8.3.3/ export LDFLAGS="-R/opt/csw/lib/:/usr/lib/" ./configure --with-libraries=/opt/csw/lib/:/usr/lib/ --with-includes=/opt/csw/include/:/usr/include/ sudo make install /usr/local/pgsql/bin/psql --version sudo mkdir /usr/local/pgsql/data sudo chown postgres:postgres /usr/local/pgsql/data/ sudo su postgres -c "/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data" svccfg export postgresql>postgresql833.smf less postgresql833.smf cp /opt/csw/lib/svc/method/postgresql /opt/csw/lib/svc/method/postgresql83 vim /opt/csw/lib/svc/method/postgresql83 chown root:bin /opt/csw/lib/svc/method/postgresql83* svccfg import postgresql833.smf svcs svcadm enable postgresql83 du -h /home/postgres/data/ df -hla sudo vim /usr/local/pgsql/data/postgresql.conf svcadm enable postgresql83 sudo su postgres -c "/usr/local/pgsql/bin/pg_dumpall -h localhost -U postgres -p 5432 | /usr/local/pgsql/bin/psql -U postgres -h localhost -p 9999" svcadm enable postgresql83 svcadm enable mongrel/facts