7.2 Upgrade problems: Cannot restore from pg_dumpall

From: Chris Lee <Chrislee(at)centurycity(dot)com(dot)hk>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: 7.2 Upgrade problems: Cannot restore from pg_dumpall
Date: 2002-02-08 06:32:52
Message-ID: A2388C941356D4119D830008C7336801013D0968@HKRHIEXC01
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2002-02-08 07:15:37 Re: 7.2 Upgrade problems: Cannot restore from pg_dumpall
Previous Message Darren Ferguson 2002-02-08 04:40:54 Re: Data in a field must be in capitals