Re: pg_upgrade as a way of cloning an instance?

From: Luca Ferrari <fluca1978(at)gmail(dot)com>
To: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_upgrade as a way of cloning an instance?
Date: 2021-07-07 08:30:15
Message-ID: CAKoxK+4M-uM8WaoSGTKdUx=Sxci-_N3s01FY=vx6fom4p+iF0A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jul 7, 2021 at 10:22 AM Peter Eisentraut
<peter(dot)eisentraut(at)enterprisedb(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2021-07-07 08:43:41 Re: Need suggestions about live migration from PG 9.2 to PG 13
Previous Message Peter Eisentraut 2021-07-07 08:22:05 Re: pg_upgrade as a way of cloning an instance?