"Christopher J. Bottaro" <cjbottaro@xxxxxxxxxxxxxxxxxxxx> writes: > 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. Something involving --no-owner should work for you. See the pg_dump man page. regards, tom lane
