[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] restoring under a different owner?
From:       "Christopher J. Bottaro" <cjbottaro () alumni ! cs ! utexas ! edu>
Date:       2006-02-19 20:25:20
Message-ID: dtak7h$c5v$1 () sea ! gmane ! org
[Download RAW message or body]

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
[prev in list] [next in list] [prev in thread] [next in thread]