Recovering from a lost or damaged database

Information about the configured physical disk and VDisks is maintained in a postgresql database located at /quadstor/pgsql. The database is present under /quadstor/pgsql/data . If /quadstor/pgsql/data directory is removed or damaged, the information can be recovered by the /quadstor/bin/dbrecover tool

In order to perform a successful database recovery, you must have installed and successfully run version 3.0.1 or later

Steps to perform a database recovery

1. Reinstall the quadstor packages (uninstalling first and the installing again) as described under http://www.quadstor.com/support/123-installation-on-rhel-centos-sles-deb... and http://www.quadstor.com/support/61-installation-on-freebsd-8-2.html. Ensure that after uninstalling you move /quadstor/pgsql/data directory to another location before installing the packages again.

2. Reboot the system

3. After the system restart ensure that quadstor service is running. Run the following command to confirm

On RHEL5/6 run /etc/rc.d/init.d/quadstor status
On Debian run /etc/init.d/quadstor status
On SLES run /etc/rc.d/quadstor status
On FreeBSD run /etc/init.d/quadstor status

4. Run /quadstor/bin/dbrecover -t

5. The above command runs the recover tool in test mode but does not change the database. The command lists the physical disks and VDisks which will added back to the database. In case the tools requires user confirmation it will prompt the user first

6. If everything is satisfactory run /quadstor/bin/dbrecover again. This time do not pass the '-t' option. Without the -t option changes are committed to the database.

7. Reboot your system

8. Your database should be recovered to a previous state.

The following information is recovered by the dbrecover tool

  • Physical storage configuration
  • VDisk configuration

The following information cannot be recovered by the dbrecover tool and will have to be manually reconfigured

  • VDisk iSCSI settings