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/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly