Is it possible to upgrade PostreSQL from 14 to 16 directly when using containers? - eviltoast

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

  • Suzune@ani.social
    link
    fedilink
    arrow-up
    4
    ·
    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.