Re: pg_restore error - Mailing list pgsql-admin

From Lee Wu
Subject Re: pg_restore error
Date
Msg-id ECAB83AA52BCC043A0E24BBC00001024111420@mxhq-exch.corp.mxlogic.com
Whole thread Raw
In response to pg_restore error  (Düster Horst <Horst.Duester@bd.so.ch>)
List pgsql-admin
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
dumplist and  
change the order of restore manually and restore with -L


-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Düster Horst
Sent: Friday, October 29, 2004 7:52 AM
To: pgsql-admin@postgresql.org
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?

Horst

-----Ursprüngliche Nachricht-----
Von: Janko Richter [mailto:jankorichter@yahoo.de]
Gesendet am: Freitag, 29. Oktober 2004 13:14
An: Düster Horst; pgsql-admin@postgresql.org
Betreff: Re: pg_restore error

Hi,

Try "pg_restore -l" to generate a TOC.
You may rearrange the TOC file.
Then use "pg_restore -L".

Hope it helps,
Janko Richter


Düster Horst wrote:
> Vishal
>
> 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]
> [mailto:vishalonlist@gmail.com]
> Gesendet am: Freitag, 29. Oktober 2004 11:33
> An: Düster Horst
> Cc: pgsql-admin@postgresql.org
> Betreff: Re: [ADMIN] pg_restore error
>
> Hi
>
>
>>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
>>hints.
>
>
>
> 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
>
> http://developer.postgresql.org/todo.php
>
> 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@postgresql.org so that your
      message can get through to the mailing list cleanly

pgsql-admin by date:

Previous
From: Chris Browne
Date:
Subject: Re: Replication Options.
Next
From: Shawn Kovalchick
Date:
Subject: Problem connecting to localhost in 7.4.2