Re: 7.2 Upgrade problems: Cannot restore from pg_dumpall

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 7.2 Upgrade problems: Cannot restore from pg_dumpall
Дата
Msg-id 23813.1013184363@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 7.2 Upgrade problems: Cannot restore from pg_dumpall  (Chris Lee <Chrislee@centurycity.com.hk>)
Список pgsql-general
Chris Lee <Chrislee@centurycity.com.hk> writes:
> 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?

That last line needs to be

\connect "Chinese" postgres

This appears to be a bug in pg_dumpall --- it should quote the database
name to avoid case-folding.  If you can hand-edit the dump script to
fix it, you should be okay.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: TIP 4: Don't 'kill -9' the postmaster
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: TIP 4: Don't 'kill -9' the postmaster