Re: 7.2 Upgrade problems: Cannot restore from pg_dumpall

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris Lee <Chrislee(at)centurycity(dot)com(dot)hk>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: 7.2 Upgrade problems: Cannot restore from pg_dumpall
Date: 2002-02-08 16:06:03
Message-ID: 23813.1013184363@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Chris Lee <Chrislee(at)centurycity(dot)com(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jason Earl 2002-02-08 16:24:44 Re: Debian package for pgsql-7.1.3
Previous Message Tom Lane 2002-02-08 16:02:48 Re: TIP 4: Don't 'kill -9' the postmaster