this post was submitted on 08 Feb 2024
4 points (83.3% liked)

PostgreSQL

652 readers
1 users here now

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

founded 1 year ago
MODERATORS
 

Is it possible to upgrade PostreSQL from 14 to 16 directly when using containers?
@postgresql

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 4 points 9 months ago

Yes. Log into the old container, dump the entire database. Rename the data directory, if it's not versioned. Upgrade start the new version. Restore from the previous dump.