Re: [pgsql-pkg-debian] problem with pg_upgradecluster frompostgresql 8.1 to 9.1

Поиск
Список
Период
Сортировка
От Christoph Berg
Тема Re: [pgsql-pkg-debian] problem with pg_upgradecluster frompostgresql 8.1 to 9.1
Дата
Msg-id 20170819083249.lg6bo6bsfbofxbeg@msg.df7cb.de
обсуждение исходный текст
Ответ на [pgsql-pkg-debian] problem with pg_upgradecluster from postgresql 8.1 to 9.1  (Giuseppe Sacco <giuseppe@eppesuigoccas.homedns.org>)
Ответы Re: [pgsql-pkg-debian] problem with pg_upgradecluster frompostgresql 8.1 to 9.1  (Giuseppe Sacco <giuseppe@eppesuigoccas.homedns.org>)
Список pgsql-pkg-debian
Re: Giuseppe Sacco 2017-08-17 <1502973744.23289.7.camel@eppesuigoccas.homedns.org>
> Hello,
> I know this is a quite old system, but I hope someone will give some
> hint on how to find the problem.
>
> I am trying to upgrade an old 8.1 cluster to 9.1 on an ubuntu dapper
> system. 9.1 is the latest installable form PGDG on that old dapper, in
> fact packages have been installed without problems.
>
> When running pg_upgradecluster, the procedure stop just after new
> cluster creation. No errors are available on the logs: the new cluster
> seems working, but the upgrade stop and write "Could not start target
> cluster".

Hi,

I can't say what the problem is - what's puzzling me is that usually
pg_upgradecluster should drop the new cluster if there are any
problems during the upgrade, but the 9.1/main cluster seems to be
running just fine for you after the upgrade attempt.

To move forward, I'd just manually do

pg_dumpall -p 5432 | psql -p 5434

That will transfer the 8.1/main contents to 9.1/main.


It's been a long time, but off-hand, I'm not aware of any specific
bugs that would explain the behavior you are seeing. Alternatively,
you could try installing a recent postgresql-common version, it should
still support 8.1.

Christoph


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

Предыдущее
От: Giuseppe Sacco
Дата:
Сообщение: [pgsql-pkg-debian] problem with pg_upgradecluster from postgresql 8.1 to 9.1
Следующее
От: Giuseppe Sacco
Дата:
Сообщение: Re: [pgsql-pkg-debian] problem with pg_upgradecluster frompostgresql 8.1 to 9.1