reference:database_restore
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
| reference:database_restore [2012/08/17 10:12] – paul | reference:database_restore [2013/02/08 08:49] – [Cleaning Up] paul | ||
|---|---|---|---|
| Line 11: | Line 11: | ||
| To restore a backup to a temporary database on the VPOP3 computer, go to a command prompt in the VPOP3\pgsql\bin folder and run a command like | To restore a backup to a temporary database on the VPOP3 computer, go to a command prompt in the VPOP3\pgsql\bin folder and run a command like | ||
| - | | + | createdb -U postgres -E SQL_ASCII -p 5433 -T template0 vpop3temp |
| (password '' | (password '' | ||
| Line 17: | Line 17: | ||
| Then, run a command like: | Then, run a command like: | ||
| - | | + | pg_restore -U postgres -p 5433 -d vpop3temp -j 4 -v dbback.dmp |
| (password '' | (password '' | ||
| Line 46: | Line 46: | ||
| Go to a command prompt in the VPOP3\pgsql\bin folder and run a command like | Go to a command prompt in the VPOP3\pgsql\bin folder and run a command like | ||
| - | | + | dropdb -U postgres -p 5433 vpop3temp |
| (password '' | (password '' | ||
reference/database_restore.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1
Page Tools
