backup / restore problem 
Author Message
 backup / restore problem

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://www.***.com/

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Sun, 19 Sep 2004 04:18:13 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. SP5 Problem - Backup/Restore problem

2. Service Pack 5 Problem - Backup/Restore Problem

3. Backup / restore problem

4. Tape multivolume backup/restore problems

5. Backup/Restore problem

6. emergency backup/restore problem...can you help?

7. database backup/restore problems

8. SQL Server Backup/Restore PROBLEMS!!

9. Backup - Restore Problems

10. Backup/restore problem

11. Backup/Restore Problem

12. Backup/restore problem


 
Powered by phpBB® Forum Software