What is a .backup format?
Some time ago i was working on a database made in Postgresql, i learned to make backups by exporting the database to a .sql file, but i recently found a .backup file with the name of the database that i was working on at that time and i don't know how to restore the database from that file since Postgresql throw me an error when i try to r开发者_如何学运维estore the database. Anyone know anything about this format and how to restore anything in it?
Postgres does have a "custom" format produced by pg_dump -Fc
. Try doing pg_restore -l <filename>
and see if it lists the file's contents.
Typically, Postgres backups are little more than large SQL scripts that are gzipped. You may want to see if you can "gzcat" the file and get any sanity out of it.
精彩评论