Did pg_dumpall and imported, NEED TO START OVER

Поиск
Список
Период
Сортировка
От Ralph Smith
Тема Did pg_dumpall and imported, NEED TO START OVER
Дата
Msg-id 72C6365E-88D8-4932-8BC8-BCD955B7D9AE@u.washington.edu
обсуждение исходный текст
Список pgsql-general
I'm preparing to upgrade and am practicing.
I'm using v7.4
I created a blank .7.4 to import a pg_dumpall  into.  (Also a v8.2 to upgrade to.)

The encoding was wrong and I have a lot of:
   psql:/tmp/cluster_pg_dumpall.txt:4382: ERROR:  invalid byte sequence for encoding "UTF8": 0x91
   HINT:  This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
   CONTEXT:  COPY brokenbin, line 443

Do I have to back out and start over?

drop database?
Or clear out and start over w/ a new install?

If the latter, what do I drop before I can start over w/ an `initdb -E SQL_ASCII`


THANKS!
Ralph Smith
=====================


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

Предыдущее
От: "Tomi N/A"
Дата:
Сообщение: Re: a failover scenario
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re : pg_dump SERIAL and SEQUENCE