Postgres Pro
Downloads
Home   >   mailing lists

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

From Christopher J. Bottaro
Subject restoring under a different owner?
Date
Msg-id dtak7h$c5v$1@sea.gmane.org
Whole thread Raw
Responses Re: restoring under a different owner?  (John DeSoi <desoi@pgedit.com>)
Re: restoring under a different owner?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

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