pg.ddx.io  pgsql-pkg-debian@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (3+ messages)  latest in thread

Message-ID: <20170819083249.lg6bo6bsfbofxbeg@msg.df7cb.de>
Permalink:  ../20170819083249.lg6bo6bsfbofxbeg@msg.df7cb.de/
Also on:    postgresql.org/message-id/20170819083249.lg6bo6bsfbofxbeg@msg.df7cb.de

 · 

reply

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