Dear all,
I am trying to restore a backup of database created by
pg_dump. But I got the following error, no matter I
use command a or b.
Why pg_restore try to create stuff while data only
option is given?
--- log ---
command (a)
su -l pgsql -c "pg_restore -d db01
/export/data/subsys/backend/archive/db01-current.tar"
command (b)
su -l pgsql -c "pg_restore -a -d db01
/export/data/subsys/backend/archive/db01-current.tar"
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit
index 'acid_event_pkey' for table 'acid_event'
Archiver(db): Could not execute query. Code = 7.
Explanation from backend: 'ERROR: Relation
'acid_event' already exists
--- log ---
Thanks for your help,
Vincent Chen
__________________________________________________
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/