Postgresql: Difference between revisions
From DWIKI
No edit summary |
mNo edit summary |
||
| Line 2: | Line 2: | ||
*[http://www.postgresql.org/ Homepage] | *[http://www.postgresql.org/ Homepage] | ||
*[http://www.freebsddiary.org/postgresql.php Postgresql on freebsd] | *[http://www.freebsddiary.org/postgresql.php Postgresql on freebsd] | ||
*[http://www.pgbarman.org/ Backups for postgresql] | |||
=Installation= | =Installation= | ||
Revision as of 12:23, 20 May 2016
Links
Installation
Postgresql on freebsd
- http://www.freebsddiary.org/postgresql.php (doesn't seem entirely right)
(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
