This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| database:postgresql [2017/12/09 01:19] – external edit 127.0.0.1 | database:postgresql [2018/03/31 10:06] (current) – [RESTORE] tmade | ||
|---|---|---|---|
| Line 94: | Line 94: | ||
| psql -f dumpfile postgres | psql -f dumpfile postgres | ||
| - | | ||
| - | To restore a DB (created with " | ||
| - | |||
| - | dropdb databasename | ||
| - | createdb databasename | ||
| - | | ||
| - | Afterwards you have to invoke: | ||
| - | |||
| - | pg_restore -d databasename databasename.dump | ||
| - | psql dbname < infile.sql | ||
| - | |||
| ==== POINT IN TIME RECOVERY ==== | ==== POINT IN TIME RECOVERY ==== | ||