Re: issue with pg_restore - Mailing list pgsql-general

From Tom Lane
Subject Re: issue with pg_restore
Date
Msg-id 7066.1311860471@sss.pgh.pa.us
Whole thread Raw
In response to Re: issue with pg_restore  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: issue with pg_restore  (Nigel Heron <nigel@psycode.com>)
List pgsql-general
Adrian Klaver <adrian.klaver@gmail.com> writes:
> On Wednesday, July 27, 2011 9:19:38 pm Nigel Heron wrote:
>> I'm trying to restore a backup into a database with a new name
>> It doesn't work .. pg_restore claims to be creating tables, indexes,
>> etc. and there are no errors in the output. It only takes a few seconds
>> to run (the file is ~250MB).

> You running the pg_restore as postgres user with sufficient privileges?

I'm wondering if it could be the same bug reported two days ago:
http://archives.postgresql.org/message-id/201107270042.22427.julian@mehnle.net
Have you got standard_conforming_strings turned on?

            regards, tom lane

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: issue with pg_restore
Next
From: Adrian Klaver
Date:
Subject: Re: List Functions and Code