User Tools

Site Tools


how_to:restore_a_database_backup

This is an old revision of the document!


Restore a database backup

If you have a valid backup of the PostgreSQL database used by VPOP3, you can restore it by performing the following steps:

  1. Open a command prompt, and go to the VPOP3 directory
  2. If you are restoring the backup over an existing VPOP3 database (especially if the database files are damaged) you will need to DROP the database first.
    1. To do this, run pgsql\bin\dropdb -U postgres vpop3. When it prompts for the password enter the PostgreSQL master password - default pgsqlpass.
    2. Then you will need to recreate the database - run pgsql\bin\createdb -E SQL_ASCII -O vpop3 -U postgres vpop3
  3. Run pgsql\bin\pg_restore -U postgres -C -d vpop3 DBBACK-<number>.DMP where <number> is the latest number of the database backup made by VPOP3. When it prompts for a password enter the PostgreSQL master password - default pgsqlpass
how_to/restore_a_database_backup.1304590661.txt.gz · Last modified: 2018/11/14 10:44 (external edit)