Hacker News new | ask | show | jobs
by pritambaral 521 days ago
Well, three ways:

1. Dump a backup to disk, then restore from dump on new version;

2. Stop the old version, then run `pg_upgrade --link` on the data of the old version which should create a new data directory using hardlinks, then start the new version using the new data directory. This is rather quick; or

3. Use Logical Replication to stand up the new version. This has ... a few caveats.