Database Recovery

Please backup your database before proceeding with recovery.

Following example assumes that you installed Reality Hub and Database by using default locations.

Recovering

To use the pg_resetwal command, follow these steps:

  1. Stop the Reality Hub Database Service.

  2. Run the following command:

"C:\Program Files\Zero Density\RealityHub\pg\bin\pg_resetwal.exe" -f "C:\ProgramData\Zero Density\RealityHub\dbdata"
Details
  • The pg_resetwal command has the potential to wipe out all transactions that haven't been completed. If there are any pending transactions that you wish to keep, ensure to back them up before using this command.

  • The pg_resetwal command doesn't only remove uncommitted transactions; it also clears any other data not yet written to the Write-Ahead Log (WAL). This includes data that's been changed but not finalized, data marked for deletion but still present, and data that's been written to the WAL but hasn't been saved to the disk yet.

  • The pg_resetwal command is quite powerful and can cause data loss. It's usually only recommended in dire situations, specifically when the Reality Hub Database Service cannot be started using conventional methods.

  1. Restart the Reality Hub Database Service.

Once the Reality Hub Database Service has restarted, you should be able to connect to it and use it as usual.