Config Postgres from binary packages on OpenSolaris

Download binary package from
http://www.postgresql.org/ftp/binary/

Choose package for solaris

Extract package

Open terminal

Point to package folder/bin

Check library link to initdb

#ldd initdb

if you see some line "Find not found", you can find it in /usr/lib

If in /usr/lib not contains that file, you can copy some file latest version back to version required

Initializing DB
#./initdb //data

using PgAdmin 3 login in to db, using current user you logged in.

Good luck!

Install PostgreSQL on OpenSolarsis

Use Package Manager , check all SUNWpost**-8.3**

Install pgAdmin3

----
Open Terminal 1

su

Setup password for postgres account:

passwd postgres

usermod -P "Postgres Administration" -R postgres bearsoft

su - postgres

If u get some error e.x : su: No shell, u should config shell apply for postgres user

Open another terminal 2,

su
gedit /etc/passwd

u change shell apply for root, bearsoft (current user), and postgres account into /bin/bash

back to terminal 1, type:

pfexec /usr/postgres/8.3/bin/initdb /var/postgres/8.3/data

Start server

/usr/postgres/8.3/bin/pg_ctl -D /var/postgres/8.3/data -l var/postgres/8.3/logfile start

done.

Tìm hiểu về PostgreSQL trên OpenSolaris

http://wikis.sun.com/display/DBonSolaris/PostgreSQL

http://blogs.sun.com/felix/

http://blogs.sun.com/jkshah