Re: 7.2 Upgrade problems: Cannot restore from pg_dumpall - Mailing list pgsql-general

From Tom Lane
Subject Re: 7.2 Upgrade problems: Cannot restore from pg_dumpall
Date
Msg-id 23813.1013184363@sss.pgh.pa.us
Whole thread Raw
In response to 7.2 Upgrade problems: Cannot restore from pg_dumpall  (Chris Lee <Chrislee@centurycity.com.hk>)
List pgsql-general
Chris Lee <Chrislee@centurycity.com.hk> writes:
> Here is the content of pg_dump.bak

> 471 \connect template1 postgres
> 472 CREATE DATABASE "Chinese" WITH TEMPLATE = template0 ENCODING = 'EUC_TW';
> 473 \connect Chinese postgres

> Any Hints?

That last line needs to be

\connect "Chinese" postgres

This appears to be a bug in pg_dumpall --- it should quote the database
name to avoid case-folding.  If you can hand-edit the dump script to
fix it, you should be okay.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: TIP 4: Don't 'kill -9' the postmaster
Next
From: Bruce Momjian
Date:
Subject: Re: TIP 4: Don't 'kill -9' the postmaster