PostgreSQL database restore from backup [closed]

Question

I'm trying to get a site up and running and have the .asp source files and a .backup of the PostgreSQL database.

I keep getting errors while trying to restore the Postgres backup: "Process returned exit code 0." I've already created a new db and added tables through the pgadmin GUI, I get the error when I right click on the empty table and select restore.

Anyone with Postgres experience available to help out, or point me in the direction of some specific documentation?

Answer 1

Use the client application pg_restore to restore from an archive created by pg_dump in one of the non-plain-text formats.