Postgres equivalent of Oracle's RMAN.VALIDATE_DATABASE



  • I am migrating a system using Oracle DB to Postgres (12.7). Various checks are run weekly against the existing DB, including a RMAN.VALIDATE_DATABASE (actually RDSADMIN.RDSADMIN_RMAN_UTIL.VALIDATE_DATABASE as it's Amazon RDS) - physical+logical type. Is there an equivalent to this with Postgres?

    The Oracle DB runs as an Amazon RDS instance, the Postgres DB is running as an Amazon Aurora instance.

    I can see that I can enable block checksums, but I don't see anything else.

    Thanks!



  • The procedure tries to ensure that the backup pieces available can be used to restore the database.
    I don't know if there's any equivalent for PostgreSQL.

    However, the only way to be absolutely certain that a database can be recovered is ... to restore [a copy of] that database.

    Just because a procedure says that everything is OK is no substitute for proper Disaster Recovery Rehearsals wherein you actually restore the database to

    • Definitively prove that the database can be restored, and
    • Remind you how to do the restore because, hopefully, it's not something that you'll be doing on a regular basis, otherwise.



Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2