From: Christoph Berg <myon@debian.org>
To: Giuseppe Sacco <giuseppe@eppesuigoccas.homedns.org>
Cc: pgsql-pkg-debian@postgresql.org
Subject: Re: problem with pg_upgradecluster from postgresql 8.1 to 9.1
Date: Sat, 19 Aug 2017 10:32:49 +0200
Message-ID: <20170819083249.lg6bo6bsfbofxbeg@msg.df7cb.de> (raw)
In-Reply-To: <1502973744.23289.7.camel@eppesuigoccas.homedns.org>
References: <1502973744.23289.7.camel@eppesuigoccas.homedns.org>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-pkg-debian>
Re: Giuseppe Sacco 2017-08-17 <camel@eppesuigoccas.homedns.org/">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
--
Sent via pgsql-pkg-debian mailing list (pgsql-pkg-debian@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-pkg-debian
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-pkg-debian@postgresql.org
Cc: myon@debian.org, giuseppe@eppesuigoccas.homedns.org
Subject: Re: problem with pg_upgradecluster from postgresql 8.1 to 9.1
In-Reply-To: <20170819083249.lg6bo6bsfbofxbeg@msg.df7cb.de>
References: <1502973744.23289.7.camel@eppesuigoccas.homedns.org> <20170819083249.lg6bo6bsfbofxbeg@msg.df7cb.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox