7.2 Upgrade problems: Cannot restore from pg_dumpall

Поиск
Список
Период
Сортировка
Искать
От
Chris Lee
Тема
7.2 Upgrade problems: Cannot restore from pg_dumpall
Дата
Msg-id
A2388C941356D4119D830008C7336801013D0968@HKRHIEXC01
Список
Дерево обсуждения
7.2 Upgrade problems: Cannot restore from pg_dumpall Chris Lee <Chrislee@centurycity.com.hk>
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>
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 по дате отправления
От: Darren Ferguson
Дата:
От: Jeff Davis
Дата:
FAQ