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 ==== | ||