Skip to content

WAL-G

WAL-G stores database backups and change logs that can be used to rebuild a database.

Visit WAL-G

What brings back a booking before it was deleted?

For PostgreSQL, start with a base backup taken before the deletion and keep the continuous change logs, called WAL, through the time you want. WAL-G can fetch the base backup and the archived logs. PostgreSQL replays the changes and stops at the recovery target you configure. A missing log in that sequence can prevent recovery to the desired time.

What do you need before restoring?

Use a separate empty data directory and a compatible PostgreSQL installation. Confirm that the copy cannot serve live traffic or send messages and that it can read the required backup and logs before it starts. The open-source project license is Apache 2.0. Budget for backup and log storage, any download charges, and the machine and disk space for the recovery. Plan separately for uploaded files stored outside PostgreSQL.

Could a fictional booking be recovered to 10:04?

Draw a 9:00 base backup, a 10:00 booking, and a 10:05 deletion.

  1. Check the log chain
    Mark the changes needed to reach 10:04. If a log is missing, record the requested restore point as unproven.
  2. Read the result
    On your diagram, recover into a separate copy. At 10:04 the booking should exist and the later deletion should be absent.