I had the problem in 7.3.2. Postgres pg_restore reied to restore views before tables. I had to use -l to generate a dump list and
change the order of restore manually and restore with -L
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Düster Horst
Sent: Friday, October 29, 2004 7:52 AM
Subject: Re: [ADMIN] pg_restore error
OK, the manual talk about this solution, but I do have more than 2000
objects in my DB. What is the reason that pg_dump/pg_restore are not able to
create an correct order ob DB objects with respect to their constraints. All
tables must be created before the views are created and so on?
Von: Janko Richter [mailto:jankorichter(at)yahoo(dot)de]
Gesendet am: Freitag, 29. Oktober 2004 13:14
An: Düster Horst; pgsql-admin(at)postgresql(dot)org
Betreff: Re: pg_restore error
Try "pg_restore -l" to generate a TOC.
You may rearrange the TOC file.
Then use "pg_restore -L".
Hope it helps,
Düster Horst wrote:
> Thank you for your answer. My problem is, I have to restore BLOBS. The
> documentation says, it's only possible to restore blobs with pg_restore in
> one part. The way you suppose does not work with BLOBS because the
> restauration of single objects will not restore BOLBS.
> Horst Düster
> -----Ursprüngliche Nachricht-----
> Von: Vishal Kashyap @ [Sai Hertz And Control Systems]
> Gesendet am: Freitag, 29. Oktober 2004 11:33
> An: Düster Horst
> Cc: pgsql-admin(at)postgresql(dot)org
> Betreff: Re: [ADMIN] pg_restore error
>>I thought, that pg_restore will organize the restore-prozess in an optimal
>>order. This seems not work correct!!?? I would be grateful to hear any
> pg_restore does not priortize till now idealy it must be like
> restoring the functions >> tables >> views >> seqences so on...
> This is in the todo
> but for mean while you would have to use pg_restore to restore the
> tables one by one and then let other thing go on.
> moreover if your database is not to large its best to make a text file
> of the dump and run it through psql
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
pgsql-admin by date
|Next:||From: Nikhil Parva||Date: 2004-10-29 17:45:54|
|Subject: unregister email@example.com|
|Previous:||From: Lee Wu||Date: 2004-10-29 16:35:10|
|Subject: Re: pg_ctl stop -m fast |