7.2 Upgrade problems: Cannot restore from pg_dumpall

Поиск
Список
Период
Сортировка
От Chris Lee
Тема 7.2 Upgrade problems: Cannot restore from pg_dumpall
Дата
Msg-id A2388C941356D4119D830008C7336801013D0968@HKRHIEXC01
обсуждение исходный текст
Ответы Re: 7.2 Upgrade problems: Cannot restore from pg_dumpall
Re: 7.2 Upgrade problems: Cannot restore from pg_dumpall
Список 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 по дате отправления:

Предыдущее
От: Darren Ferguson
Дата:
Сообщение: Re: Data in a field must be in capitals
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: 7.2 Upgrade problems: Cannot restore from pg_dumpall