Adrian Klaver <adrian.klaver@xxxxxxxxx> 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@xxxxxxxxxx Have you got standard_conforming_strings turned on? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general