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 12a7a897-ff85-5280-7721-5e6d0e7cb30b@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>)
List pgsql-general
On 2/27/23 08:48, Tom Lane wrote:
> Adrian Klaver <adrian.klaver@aklaver.com> writes:
>> On 2/27/23 08:36, Tom Lane wrote:
>>> 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?
> 
> No, but the OP didn't mention whether he used that, and even if he
> didn't say it explicitly the pg_upgradecluster wrapper might've
> supplied it.

Alright the OP's command was:

pg_upgradecluster 9.6 main

pg_upgradecluster needs the --link(-k) option to use link instead of copy.

> 
>             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: Adrian Klaver
Date:
Subject: Re: pg_upgradecluster transfering only a portion of the data