Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
database:postgresql [2017/12/09 01:19]
127.0.0.1 external edit
database:postgresql [2018/03/31 10:06] (current)
tmade [RESTORE]
Line 94: Line 94:
  
   psql -f dumpfile postgres ​              #"​postgres"​ is the owner of the db!   psql -f dumpfile postgres ​              #"​postgres"​ is the owner of the db!
-  ​ 
-To restore a DB (created with "​pg_dump"​) you have: 
- 
-  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 ====
  
database/postgresql.txt ยท Last modified: 2018/03/31 10:06 by tmade
 
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki