If you have an existing installation running an earlier version of PostgreSQL and you wish to
migrate to a later version of PostgreSQL you should follow this method provided by BVR.
Note: All commands must be run as root, or as a user with root privileges using the sudo command.
The method is as follows
- While using the earlier version of PostgreSQL run the bdb backup command to save the database contents.
- Install the later version of PostgreSQL
following the instructions in Installing PostgreSQL Database for Blueworx CPD
- Run the bdb remove command to ensure the database is empty. Ignore any error saying "bw_db" does not exist".
- Now using the later version of PostgreSQL run the bdb restore command to set the database contents using the output of the
earlier bdb backup.