Enable root account OpenSolaris

su
gedit /etc/user_attr

Remove first element , final resule seems:

root::::type=normal;....

reboot system

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.