restoring under a different owner?

From: "Christopher J(dot) Bottaro" <cjbottaro(at)alumni(dot)cs(dot)utexas(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: restoring under a different owner?
Date: 2006-02-19 20:25:20
Message-ID: dtak7h$c5v$1@sea.gmane.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael MacLennan 2006-02-19 20:40:10 Re: connecting to pgsql
Previous Message Mike Nolan 2006-02-19 18:56:00 Backslashes in data in version 8.1.2