From: Janko Richter <jankorichter@yahoo.de>
To: Düster Horst <Horst.Duester@bd.so.ch>
To: pgsql-admin@postgresql.org
Subject: Re: pg_restore error
Date: Fri, 29 Oct 2004 14:14:15 +0200
Message-ID: <41823417.3010200@yahoo.de> (raw)
In-Reply-To: <5B025B1F39D6D4119F5700508BEEEC66F94BF5@SRSOFAIOI4546>
References: <5B025B1F39D6D4119F5700508BEEEC66F94BF5@SRSOFAIOI4546>
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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jankorichter@yahoo.de, Horst.Duester@bd.so.ch
Subject: Re: pg_restore error
In-Reply-To: <41823417.3010200@yahoo.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox