Re: problem with pg_upgradecluster from postgresql 8.1 to 9.1

Re: Giuseppe Sacco 2017-08-17 <1502973744(dot)23289(dot)7(dot)camel(at)eppesuigoccas(dot)homedns(dot)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