Re: pg_upgrade as a way of cloning an instance? - Mailing list pgsql-general

From Luca Ferrari
Subject Re: pg_upgrade as a way of cloning an instance?
Date
Msg-id CAKoxK+4M-uM8WaoSGTKdUx=Sxci-_N3s01FY=vx6fom4p+iF0A@mail.gmail.com
Whole thread Raw
In response to Re: pg_upgrade as a way of cloning an instance?  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Responses Re: pg_upgrade as a way of cloning an instance?
List pgsql-general
On Wed, Jul 7, 2021 at 10:22 AM Peter Eisentraut
<peter.eisentraut@enterprisedb.com> wrote:
> Yeah, seems pretty pointless.  You can just copy the data directory
> directly and get the same effect.  pg_upgrade basically does a data
> directory copy plus some extra stuff to convert the system catalogs
> between versions, and if you don't need that second part, you might as
> well do the first part directly.


Agree on everything, but I was curious, since users sometime find ways
to do things that are almost insane!

Thanks,
Luca



pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pg_upgrade as a way of cloning an instance?
Next
From: Magnus Hagander
Date:
Subject: Re: Need suggestions about live migration from PG 9.2 to PG 13