Re: problem with pg_upgradecluster from postgresql 8.1 to 9.1

From: Giuseppe Sacco <giuseppe(at)eppesuigoccas(dot)homedns(dot)org>
To: pgsql-pkg-debian(at)postgresql(dot)org
Subject: Re: problem with pg_upgradecluster from postgresql 8.1 to 9.1
Date: 2017-08-22 07:02:33
Message-ID: 1503385353.23289.49.camel@eppesuigoccas.homedns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-debian

Hello Christoph,
I tried to follow your suggestion as described here:

Il giorno sab, 19/08/2017 alle 10.32 +0200, Christoph Berg ha
scritto:[...]
> 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

and, indeed, the cluster copy started. Unfortunately this ended up in a
disk full. This is quite strange since the old cluster disk usage is
about 68Gb, while the new cluster arrived to 119Gb and filled the file
system.

I might enlarge the file system and try again, but 119Gb against 68Gb
sounds strange to me. I'll try to start again the complete operation
and save psql output and postgresql log. (Now I already dropped 9.1
cluster and even its logs were deleted.)

Bye,
Giuseppe

In response to

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message Vicky Vergara 2017-08-25 11:43:51 Fwd: Pre-release 2.5.0-alpha
Previous Message Christoph Berg 2017-08-19 08:32:49 Re: problem with pg_upgradecluster from postgresql 8.1 to 9.1