How to examine the contents of a database backup

0
Hello, I have a copy of a database-only backup in a .backup file. Is there a way I can “unzip” this or look at the contents of this database backup? I can’t find any information on this in the documentation or forum. A few people in the forums have briefly mentioned “unzipping” a backup, but not how. Thanks
asked
1 answers
2

Emily,

You can restore that backup into a new Postgres database.  Then you’ll be able to look at the contents of the database tables using the query tool in pgAdmin.  You can find instructions how to restore a database backup to Postgres here:  https://docs.mendix.com/developerportal/operate/restore-backup-locally

Hope that helps,

Mike

answered