Postgresql

From DWIKI
Revision as of 11:25, 3 November 2017 by Tony (talk | contribs) (→‎FAQ)

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

ERROR: character 'xxx' of encoding "UTF8" has no equivalent in "LATIN9" locale

Check

show server_encoding
show client_encoding
\encoding

List users

su to postgres, psql and then \du