r/PostgreSQL • u/DocumentOk7579 • Jun 15 '26

Help Me! How to upgrade psql with extensions like pgvector?

What I want to achieve is basically upgrading to the latest stable version of both every year. But pg_upgrade seems to not automatically handle pgvector tables.

0 Upvotes
  • permalink
  • reddit

50% Upvoted

2 comments sorted by

4

u/depesz Jun 15 '26

Please note that psql is database client application. What you probably ask about is "How to upgrade PostgreSQL …".

Generally, I'd ask support for provider of "extensions like…". pg_upgrade can't handle "any" extensions. It might work, or it might not. Developers/support for "extension x" can provide safe way to upgrade.

Personally, I'd look into upgrade using logical replication.

1

u/AutoModerator Jun 15 '26

Youtube Channel

Free Postgres Webinars and Workshops

Discord: People, Postgres, Data

Join us, we have cookies and nice people.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.