User Tools
docu:csheet:sysadm:db:psql:dumping
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
docu:csheet:sysadm:db:psql:dumping [2020/02/21 16:12] admin |
docu:csheet:sysadm:db:psql:dumping [2021/06/08 13:46] (current) admin |
||
|---|---|---|---|
| Line 15: | Line 15: | ||
| Restoring comands | Restoring comands | ||
| <code bash> | <code bash> | ||
| + | # create user if needed (with password) | ||
| + | createuser -P username | ||
| + | |||
| + | # drop and create the database | ||
| + | dropdb DATABASE | ||
| + | createdb DATABASE | ||
| + | |||
| + | # restore it from .sql dump file | ||
| psql --set ON_ERROR_STOP=on DATABASE < INFILE.sql | psql --set ON_ERROR_STOP=on DATABASE < INFILE.sql | ||
| </ | </ | ||
docu/csheet/sysadm/db/psql/dumping.1582301539.txt.gz · Last modified: 2020/02/21 16:12 by admin
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
