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 по дате отправления