Postgres Pro
Downloads
Home   >   mailing lists

Re: restoring under a different owner? - Mailing list pgsql-general

From Tom Lane
Subject Re: restoring under a different owner?
Date
Msg-id 14247.1140387487@sss.pgh.pa.us
Whole thread Raw
In response to restoring under a different owner?  ("Christopher J. Bottaro" <cjbottaro@alumni.cs.utexas.edu>)
List pgsql-general
Tree view 
"Christopher J. Bottaro" <cjbottaro@alumni.cs.utexas.edu> 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

pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: restoring under a different owner?
Next
From: Tom Lane
Date:
Subject: Re: Backslashes in data in version 8.1.2