postgre92 freebsd setup snipp

gistfile1.txt

# freebsd-10
# php55, postgresql92-client
# search and install postgresql92-server

root# pkg search postgre
root# pkg install ...
root# passwd pgsql                                // set password
root# su pgsql                                    
root# vi /usr/local/pgsql/data/postgresql.conf    // listen_addresses='*' for remote connection (dev mode)
pgsql# initdb -D /usr/local/pgsql/data

root# echo 'setenv PGDATA /usr/local/pgsql/data' >> .cshrc     // easy start, stop ...
root# echo 'postgresql_enable="YES"' >> /etc/rc.conf          // autoload
root# echo 'php_fpm_enable="YES"' >> /etc/rc.conf          // autoload

pgsql# pg_ctl start -l /usr/local/pgsql/serverlog