pg_restore returns error schema objects already exist
От | DavidF@nhb.org |
---|---|
Тема | pg_restore returns error schema objects already exist |
Дата | |
Msg-id | F819F04434B0E845BF4EA9115F90EE4D654700@sunflower.nhb.org обсуждение исходный текст |
Ответы |
Re: pg_restore returns error schema objects already exist
Re: pg_restore returns error schema objects already exist |
Список | pgsql-novice |
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
В списке pgsql-novice по дате отправления: