PostgreSQL Backup Information

Posted on

Question :

How do you get the Backup History for a PostgreSQL database from within the database?

for example:
in SQL Server you look into msdb.dbo.backupset
in Oracle you check v$rman_output

is there a similar way here


Answer :

A PostgreSQL backup leaves no trace in the database. If you use WAL archiving, you will get a *.backup file for each online file system backup in the WAL archive directory, but that’s all.

You best use a third-party backup solution like pgBackRest, which will provide such information.

Leave a Reply

Your email address will not be published. Required fields are marked *