Re: pg_upgradecluster transfering only a portion of the data - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_upgradecluster transfering only a portion of the data
Date
Msg-id 372205.1677515818@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_upgradecluster transfering only a portion of the data  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: pg_upgradecluster transfering only a portion of the data  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Adrian Klaver <adrian.klaver@aklaver.com> writes:
> On 2/27/23 07:44, Dávid Suchan wrote:
>> After a successful prompt finished, I checked the database and the size 
>> went from originally 20gb (in 9.6) to 700~ mb (in 14) while the disk 
>> space available shrank by about 2gb meaning that there is still the 20gb 
>> of data. I tried the entire process twice (since I had created an AWS 

> 1) How did you measure the size of the database clusters?

If it was based on something like "du", perhaps the measurement
was fooled by the fact that most of the data files will be hard-linked
between the old and new clusters.

            regards, tom lane



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_upgradecluster transfering only a portion of the data
Next
From: Adrian Klaver
Date:
Subject: Re: pg_upgradecluster transfering only a portion of the data