backup / restore problem

From: Vincent Chen <vctw(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: backup / restore problem
Date: 2002-04-01 06:04:17
Message-ID: 20020401060417.78434.qmail@web20004.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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/

Browse pgsql-admin by date

  From Date Subject
Next Message Gill, Jeffrey L 2002-04-01 17:48:37 How much memory does postgresql require?
Previous Message Greg Sikorski 2002-03-31 19:25:11 Re: <= Index.