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

From Adrian Klaver
Subject Re: pg_upgradecluster transfering only a portion of the data
Date
Msg-id 1488b8f2-fe98-3be2-0d27-4c52734f15af@aklaver.com
Whole thread Raw
In response to Re: pg_upgradecluster transfering only a portion of the data  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_upgradecluster transfering only a portion of the data  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 2/27/23 08:36, Tom Lane wrote:
> 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.

Does that happen without the --link option?

> 
>             regards, tom lane

-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_upgradecluster transfering only a portion of the data
Next
From: Tom Lane
Date:
Subject: Re: pg_upgradecluster transfering only a portion of the data