Postgresql: Difference between revisions
From DWIKI
mNo edit summary |
|||
| Line 21: | Line 21: | ||
==Back up postgresql databases== | ==Back up postgresql databases== | ||
*[https://www.postgresql.org/docs/current/backup.html Backup and Restore] | *[https://www.postgresql.org/docs/current/backup.html Backup and Restore] | ||
pg_restore --disable-triggers --clean -d davical /tmp/davical | |||
=FAQ= | =FAQ= | ||
==Create user== | ==Create user== | ||
Revision as of 22:06, 1 October 2023
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
HOWTO
Back up postgresql databases
pg_restore --disable-triggers --clean -d davical /tmp/davical
FAQ
Create user
su - postgres createuser
or in psql:
CREATE DATABASE yourdbname CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass' GRANT ALL PRIVILEGES ON DATABASE yourdbname TO youruser
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
Delete user
drop user
