Re: restoring under a different owner?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Christopher J(dot) Bottaro" <cjbottaro(at)alumni(dot)cs(dot)utexas(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: restoring under a different owner?
Date: 2006-02-19 22:18:07
Message-ID: 14247.1140387487@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Christopher J. Bottaro" <cjbottaro(at)alumni(dot)cs(dot)utexas(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-02-19 22:23:01 Re: Backslashes in data in version 8.1.2
Previous Message John DeSoi 2006-02-19 21:01:58 Re: restoring under a different owner?