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

From Chris Lee
Subject 7.2 Upgrade problems: Cannot restore from pg_dumpall
Date
Msg-id A2388C941356D4119D830008C7336801013D0968@HKRHIEXC01
Whole thread Raw
Responses Re: 7.2 Upgrade problems: Cannot restore from pg_dumpall  (Jeff Davis <list-pgsql-general@dynworks.com>)
Re: 7.2 Upgrade problems: Cannot restore from pg_dumpall  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

I following INSTALL instruction, however I got error on Step 4.
I issue the follow command:
$ su - postgres
$ /usr/local/pgsql/bin/psql -d template1 -f /tmp/pg_dump.bak

Error message:

CREATE DATABASE
psql:/tmp/pg_dump.bak:473: \connect: FATAL 1:  Database "chinese" does not
exist in the system catalog.
copying template1 to template0... ok

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?

Regards,
Chris Lee

pgsql-general by date:

Previous
From: Darren Ferguson
Date:
Subject: Re: Data in a field must be in capitals
Next
From: Jeff Davis
Date:
Subject: Re: 7.2 Upgrade problems: Cannot restore from pg_dumpall