Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dizBm-0000Tr-6V for pgsql-pkg-debian@arkaria.postgresql.org; Sat, 19 Aug 2017 08:33:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dizBk-0005V8-LZ for pgsql-pkg-debian@arkaria.postgresql.org; Sat, 19 Aug 2017 08:33:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dizBf-0005NT-24 for pgsql-pkg-debian@postgresql.org; Sat, 19 Aug 2017 08:32:55 +0000 Received: from feynman.df7cb.de ([195.49.152.168]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dizBb-00055z-Fy for pgsql-pkg-debian@postgresql.org; Sat, 19 Aug 2017 08:32:54 +0000 Received: from msg.df7cb.de (port-92-192-114-154.dynamic.qsc.de [92.192.114.154]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id 3xZCrL1knCz3Dyv; Sat, 19 Aug 2017 10:32:50 +0200 (CEST) Date: Sat, 19 Aug 2017 10:32:49 +0200 From: Christoph Berg To: Giuseppe Sacco Cc: pgsql-pkg-debian@postgresql.org Subject: Re: problem with pg_upgradecluster from postgresql 8.1 to 9.1 Message-ID: <20170819083249.lg6bo6bsfbofxbeg@msg.df7cb.de> Mail-Followup-To: Christoph Berg , Giuseppe Sacco , pgsql-pkg-debian@postgresql.org References: <1502973744.23289.7.camel@eppesuigoccas.homedns.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1502973744.23289.7.camel@eppesuigoccas.homedns.org> User-Agent: NeoMutt/20170113 (1.7.2) X-Mailing-List: pgsql-pkg-debian List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: Precedence: bulk Sender: pgsql-pkg-debian-owner@postgresql.org 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 -- 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