pg_upgrade

See every discussion that mentions pg_upgrade

Brand Details

Type: Product

Description: pg_upgrade is a PostgreSQL utility for upgrading a database cluster between major versions without data dump and restore. It reuses existing data files by populating a new cluster with data from the older one, copying system catalog information and creating hard links to data files. It verifies binary compatibility of the clusters but not external modules. It's not needed for minor version upgrades. Before using it, review release notes and back up the database. Limitations include inability to handle changes to data file formats.

Website: https://postgresql.org

Mention Analytics

Total Mentions: 7

Subreddit Mentions:

Positive Mentions: 6

Negative Mentions: 0

Sign up to filter, search, and track the sentiment of all brand mentions for pg_upgrade over time.

PositiveSoftware Recommendation

💬 22 comments

⬆︎ 21 upvotes

pg_upgrade with the --link option is suggested for minimal downtime.

Found in /r/PostgreSQL/
PositiveSoftware Recommendation

💬 7 comments

⬆︎ 0 upvotes

pg_upgrade is mentioned as a robust alternative for upgrading PostgreSQL outside of Docker.

Found in /r/PostgreSQL/
PositiveSoftware Recommendation

💬 29 comments

⬆︎ 15 upvotes

pg_upgrade is suggested as a tool for in-place upgrades to newer PostgreSQL versions.

Found in /r/PostgreSQL/

Jul 31, 2024

Migrate from 9.6 to 16 - Best option for minimal downtime?

PositiveSoftware Recommendation

💬 16 comments

⬆︎ 8 upvotes

pg_upgrade is mentioned as a method for upgrading the database in place, but it requires careful testing and may have downtime.

Found in /r/PostgreSQL/

Jun 7, 2021

Mission Impossible: Upgrading The Borg

PositiveSoftware Recommendation

💬 46 comments

⬆︎ 20 upvotes

pg_upgrade is mentioned as a tool for upgrading Postgres, and users discuss its robustness and potential challenges.

Found in /r/PostgreSQL/

Oct 9, 2020

Logical Replication Disaster

PositiveSoftware Recommendation

💬 13 comments

⬆︎ 19 upvotes

Mentioned as an alternative upgrade method that might have avoided the issues encountered with logical replication. However, it wasn't used in this instance.

Found in /r/PostgreSQL/

Oct 13, 2017

Now that 10 is out, here's a pg_upgrade tip

NeutralSoftware Recommendation

💬 18 comments

⬆︎ 26 upvotes

The commenter finds the tip not very useful because pg_upgrade already generates a script to do the vacuuming, thus diminishing the value of the original tip.

Found in /r/PostgreSQL/

Subscribe to our newsletter!

Stay up to date on how the latest changes in AI might impact your marketing plan.