Re: server closed the connection unexpectedly

Поиск
Список
Период
Сортировка
От Douglas McNaught
Тема Re: server closed the connection unexpectedly
Дата
Msg-id 87ejtla25m.fsf@suzuka.mcnaught.org
обсуждение исходный текст
Ответ на Re: server closed the connection unexpectedly  ("Mark Greenbank" <mark.greenbank@gmail.com>)
Ответы Re: server closed the connection unexpectedly  ("Mark Greenbank" <mark.greenbank@gmail.com>)
Список pgsql-general
"Mark Greenbank" <mark.greenbank@gmail.com> writes:

> 1) I'm assuming that if I update 7.3.2 to 7.3.15 I can leave the data in place
> (that is, without doing a dump/restore) -- is this correct?

Yes--minor releases don't require dump/restore.

> 2) If I up upgrade to 8.x can just copy the data files or do I have to do a
> dump/restore? The latter would be hard since pg_dump also fails on this same
> table and pg_dump doesn't seem to have an 'ignore table' option.

You would use the 8.x pg_dump in this case (against the 7.3 database),
which may or may not help if you have corrupted table data.  If that's
the problem, it's best to fix the corruption before trying to upgrade.

-Doug

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

Предыдущее
От: Geoffrey
Дата:
Сообщение: Re: server closed the connection unexpectedly
Следующее
От: "Mark Greenbank"
Дата:
Сообщение: Re: server closed the connection unexpectedly