Postgresql

From DWIKI

Links

Installation

Postgresql on freebsd


(pg_ctl: could not read file "/usr/local/pgsql/data/postmaster.opts") : After installing and creating db: As user pgsql

/usr/local/bin/postmaster -D /usr/local/pgsql/data
pg_ctl stop

Ater which it should be possible to run ( as root again)

/usr/local/etc/rc.d/postgresql start

FAQ

Create user

su - postgres
createuser