PSCS Wiki

User Tools

Site Tools

Trace: • How to estimate Database Upgrade Time
how_to:estimate_db_upgrade_time

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
how_to:estimate_db_upgrade_time [2012/02/14 15:59] – paulhow_to:estimate_db_upgrade_time [2018/11/14 10:45] (current) – external edit 127.0.0.1
Line 14: Line 14:
 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''  (password is 'pgsqlpass')   - Run ''pgsql\bin\createdb -U postgres -E SQL_ASCII -O vpop3 -T template0 vpop3test''  (password is 'pgsqlpass')
-  - Run ''pgsql\bin\pg_restore -v -d vpop3test -U postgres database.dmp'' (password is 'vpop3pass')+  - Run ''pgsql\bin\pg_restore -v -d vpop3test -U postgres database.dmp'' (password is 'pgsqlpass')
  
 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
how_to/estimate_db_upgrade_time.1329235151.txt.gz · Last modified: 2018/11/14 10:44 (external edit)

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki