"Christopher J. Bottaro" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
