{{parent page="PostgreSql"}}

==Postgresql install==
Installing postgres from source
%%
./configure
gmake
gmake install
useradd postgres
mkdir -p /usr/local/pgsql/data
chown postgres:postgres /usr/local/pgsql/data
su - postgres
initdb -D /usr/local/pgsql/data
postmaster -D /usr/local/pgsql/data > logfile 2>&1 &
createdb test
psql test

cd postgresql-version/contrib/tsearch2
make
make install
%%