When upgrading from VPOP3 version 3 or 4 to version 5, the PostgreSQL database engine needs to be upgraded. This involves backing up the database data, upgrading the database engine, then restoring the data. This can take some time on large databases.
To estimate how long this process will take, you can do the following steps:
pgsql\bin\pg_dump -v -F c -U vpop3 -f database.dmp
By timing this process you will know how long it takes to backup the database data.
Then, do a test restore.
At the command prompt in the VPOP3 directory:
pgsql\bin\createdb -U postgres -E SQL_ASCII -O vpop3 -T template0 vpop3test
(password is 'pgsqlpass')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
Then, to clean up:
pgsql\bin\dropdb -U postgres vpop3test
(password is 'pgsqlpass')