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

From Luca Ferrari
Subject pg_upgrade as a way of cloning an instance?
Date
Msg-id CAKoxK+7GD7_y2q9+DBMRa6H4WuWmKvUYo5S5Y=paG-rcf+EjgQ@mail.gmail.com
Whole thread Raw
Responses Re: pg_upgrade as a way of cloning an instance?  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
List pgsql-general
Hi all,
someone pointed me out that pg_upgrade can be used to do a clone of
the database, specifying the same binaries such as

pg_upgrade -B /usr/pgsql-13/bin -b /usr/pgsql-13/bin -D /data/clone -d /data/src

I tested it and it seems to work, even if I don't see any point in
running it (and most notably it requires a downtime on the original
cluster).
Any opinion about that?

Thanks,
Luca



pgsql-general by date:

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