Is it possible to upgrade PostreSQL from 14 to 16 directly when using containers? (social.touha.me)

submitted 5 months ago* (last edited 5 months ago) by [email protected] to c/[email protected]

1 comments fedilink hide all child comments

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

top 1 comments

sorted by: hot top controversial new old

[-] [email protected] 4 points 5 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.

this post was submitted on 08 Feb 2024

5 points (100.0% liked)

PostgreSQL

612 readers

1 users here now

The world's most advanced open source relational database

Project

About (history)
Docs
Donate to PostgreSQL
Wiki
Planet PostgreSQL
IRC
Mailing lists:
- pgsql-announce
- pgsql-hackers (developers)
- pgsql-general
- pgsql-jobs
User Groups

Events

SEAPUG Summer BBQ, 6 July in Seattle
SFBA PostgreSQL Meetup, 12 July
Chicago PostgreSQL Meetup, 19 July
PGDay UK 2023, 12 September in London
PGConf 2023, 3-5 October in New York City
PGDay Israel 2023, 19 October
PGConf.EU 2023, 12-15 December in Prague

Podcasts

postgres.fm (feed)

Related Fediverse communities

c/SQL on programming.dev
#sql on Mastodon
#postgresql on Mastodon

founded 1 year ago

MODERATORS

[email protected]