Re: issue with pg_restore

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