Hi -
I'm working with postgres for the first time, and trying to do some trial
backups and restores. The pg_dump command is working fine, both through
pgadmin III and at the shell. For example, "pg_dump -F c -b -v -f
/pgbackups/mydb2dump.backup mydb2". According to the online manual, I need
to manually recreate the database prior to restoring it (or I can use the -C
option in pg_restore to do this). However, when I use pg_restore, it always
complains that objects in the schema already exist. "pg_restore -C -d
template1 /pgbackups/mydb2dump.backup" returns with "pg_restore:
[archiver(db)] could not execute query: ERROR: schema "information_schema"
already exists". This is, again, both at the shell and with pgadmin. Am I
missing some option, or misunderstanding the process? My goal is to be able
to restore the entire database, including the schema, so that I can rebuild
my ListManager server from scratch in a disaster recovery. Thanks a bunch in
advance!
David Fenske
Information Technology Administrator
National Honey Board
davidf@nhb.org
(303)776-2337 x 27