Re: pg_restore fails

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_restore fails
Date: 2005-09-22 15:57:54
Message-ID: dguka5$80n$2@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 16.09.2005 07:31, Victor Sudakov wrote:
> Is there any way to fix or workaround this except editing the dump with a text editor (very frustrating with dozens of objects in several schemas being out of order)?

In case you only have a text dump.. uhm.. No.
In case it's a binary dump, using a newer version of pg_restore (8.0
oder 8.1 for example) with -i option should fix it to my understanding.

Best regards,
Hannes Dorbath

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Keith 2005-09-22 16:49:24 Re: Copy command not writing complete data to text file
Previous Message Hannes Dorbath 2005-09-22 15:43:27 Re: Is pgdump_all == pg_dumpall -g + pg_dump of individual databases