Friday, May 8, 2009

Install postgresql-8.3.3 on FreeBSD6.4


tar xvjf postgresql-8.3.3.tar.bz2
./configure
gmake
su
gmake install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &
netstat -an
tcp4 127.0.0.1:5432

No comments: