Hi, I want to use pg_dump to backup an entire Postgres database, including BLOB data. Then I want to restore it on a different machine with a different db owner and all the tables restored under that owner. I want the restore to create the db and all the tables.
What are the commands to do this? Thank you. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
