| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| 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 21:01:58 |
| Message-ID: | E07D4323-1136-4BF3-9075-AA3A134B27C3@pgedit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Feb 19, 2006, at 3:25 PM, Christopher J. Bottaro wrote:
> 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?
See the --no-owner option with pg_restore (also available with pg_dump).
http://www.postgresql.org/docs/8.0/interactive/app-pgrestore.html
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-02-19 22:18:07 | Re: restoring under a different owner? |
| Previous Message | Michael MacLennan | 2006-02-19 20:40:10 | Re: connecting to pgsql |