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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
