Re: pg_upgrade and rsync - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_upgrade and rsync
Date
Msg-id 11643.1422370259@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_upgrade and rsync  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: pg_upgrade and rsync
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Fri, Jan 23, 2015 at 1:48 PM, Andres Freund <andres@2ndquadrant.com> wrote:
>> I don't understand why that'd be better than simply fixing (yes, that's
>> imo the correct term) pg_upgrade to retain relfilenodes across the
>> upgrade. Afaics there's no conflict risk and it'd make the clusters much
>> more similar, which would be good; independent of rsyncing standbys.

> +1.

That's certainly impossible for the system catalogs, which means you
have to be able to deal with relfilenode discrepancies for them, which
means that maintaining the same relfilenodes for user tables is of
dubious value.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: pg_upgrade and rsync
Next
From: David Fetter
Date:
Subject: Re: Parallel Seq Scan