how_to:estimate_db_upgrade_time
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revisionLast revisionBoth sides next revision | ||
| how_to:estimate_db_upgrade_time [2011/11/18 14:14] – created paul | how_to:estimate_db_upgrade_time [2012/02/21 11:09] – paul | ||
|---|---|---|---|
| Line 5: | Line 5: | ||
| - Go to a command prompt on the VPOP3 computer, and go to the VPOP3 directory. | - Go to a command prompt on the VPOP3 computer, and go to the VPOP3 directory. | ||
| - | - Run pgsql\bin\pg_dump -v -F c -U vpop3 -f database.dmp | + | - Run '' |
| - At the password prompt, type vpop3pass (This assumes a standard installation, | - At the password prompt, type vpop3pass (This assumes a standard installation, | ||
| Line 13: | Line 13: | ||
| At the command prompt in the VPOP3 directory: | At the command prompt in the VPOP3 directory: | ||
| - | - Run pgsql\bin\createdb -U postgres -E SQL_ASCII -O vpop3 -T template0 vpop3test | + | - Run '' |
| - | - Run pgsql\bin\pg_restore -v -d vpop3test -U postgres database.dmp | + | - Run '' |
| - | - At the password | + | |
| By timing this process you will know how long it takes to restore the database data | By timing this process you will know how long it takes to restore the database data | ||
| Then, to clean up: | Then, to clean up: | ||
| - | - Run pgsql\bin\dropdb -U postgres vpop3test | + | - Run '' |
how_to/estimate_db_upgrade_time.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1
Page Tools
