docker-postgres-upgrade

a PoC for using "pg_upgrade" inside Docker -- learn from it, adapt it for your needs; don't expect it to work as-is! (by tianon)

Docker-postgres-upgrade Alternatives

Similar projects and alternatives to docker-postgres-upgrade

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better docker-postgres-upgrade alternative or higher similarity.

docker-postgres-upgrade reviews and mentions

Posts with mentions or reviews of docker-postgres-upgrade. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-08-09.
  • When Did Postgres Become Cool?
    3 projects | news.ycombinator.com | 9 Aug 2023
    Ah, looks like psql seems to have switched to actually using minor and major versions properly during the last two years - I remember the dance from the 9.x versions and postgres-upgrade [1].

    In any case it's way more straightforward with mysql.

    [1] https://hub.docker.com/r/tianon/postgres-upgrade

  • A PostgreSQL Docker container that automatically upgrades PostgreSQL
    9 projects | news.ycombinator.com | 16 Jul 2023
    Related: https://github.com/tianon/docker-postgres-upgrade
  • I upgraded from Debian Bullseye to Bookworm, and it went very well
    1 project | /r/debian | 21 Apr 2023
    Also don't forget to pg_dump before the upgrade, as the binaries for previous Postgres version might not exist anymore after the upgrade... Otherwise, https://hub.docker.com/r/tianon/postgres-upgrade/ might be helpful (haven't used it though).
  • In MySQL, never use “utf8”. Use “utf8mb4”
    8 projects | news.ycombinator.com | 12 Jan 2022
    > When you say "complex ride" what does that mean?

    On managed postgresql services like RDS it's easy, yes, because Amazon does all of the nasty work for you and has already seen all the kinks you may run into.

    If you are on your own and using Docker, you essentially need a third-party image that has the old and new binaries (https://github.com/tianon/docker-postgres-upgrade).

    If you are on your own and are using distribution packages, it's more complicated (https://blog.samuel.domains/blog/tutorials/from-stretch-to-b...).

    If you are on your own and use postgres from source, well... have fun, there's a reason why I prefer using distribution-maintained packages when possible.

  • A note from our sponsor - WorkOS
    workos.com | 26 Apr 2024
    The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →

Stats

Basic docker-postgres-upgrade repo stats
4
992
6.5
2 months ago

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com