Re: pg_upgradecluster transfering only a portion of the data

From: Dávid Suchan <david(dot)suchan(dot)ds(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_upgradecluster transfering only a portion of the data
Date: 2023-02-27 17:18:48
Message-ID: CAHD9QtYATAaZd9SK+iZccG34Zb1fDS+X6pjsNHWRc9Y=RPmwQQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I did not use the -k --link argument while upgrading as that I presume does
not copy the data

Dňa po 27. 2. 2023, 18:10 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
napísal(a):

> On 2/27/23 09:05, Dávid Suchan wrote:
>
> Please use Reply All
> Ccing list
>
> > My bad,
> > \l+ lists databases and their respective sizes- I used that and also
> > pg_size_pretty(), the result size was the same - before it was 20gb for
> > the biggest db, after it was 700mb.
> > I counted rows before the upgrade in one of the biggest and most
> > important table that I was watching and comparing - before there were
> > hundreds of thousands or millions of rows(not sure about the exact
> > number, just a lot), after the upgrade only like 15, but the first 15
> > rows matched after the upgrade when I checked with select of that table.
> >
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2023-02-27 17:40:57 Re: pg_upgradecluster transfering only a portion of the data
Previous Message Adrian Klaver 2023-02-27 17:10:28 Re: pg_upgradecluster transfering only a portion of the data