A PostgreSQL Docker container that automatically upgrades PostgreSQL

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

Our great sponsors
  • Onboard AI - Learn any GitHub repo in 59 seconds
  • InfluxDB - Collect and Analyze Billions of Data Points in Real Time
  • SaaSHub - Software Alternatives and Reviews
  • docker-pgautoupgrade

    A PostgreSQL Docker container that automatically upgrades your database

  • 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!

  • Onboard AI

    Learn any GitHub repo in 59 seconds. Onboard AI learns any GitHub repo in minutes and lets you chat with it to locate functionality, understand different parts, and generate new code. Use it for free at www.getonboard.dev.

  • pgsql-backup

    PostgreSQL Backup Script. Ported from AutoMySQLBackup.

  • pgkit

    Pgkit - Backup, PITR and recovery management made easy

  • PostgreSQL-Disaster-Recovery-With-Barman

    A complete end-end project that demonstrates the 'Traditional backup with WAL streaming' architecture implementation (Backup via rsync/SSH + WAL streaming). This is chosen as it provides incremental backup/restore & a bunch of other features.

    > The database will then start replaying the WAL files. It's progress can be tracked through the log files at /var/log/postgresql/.

    - "PostgreSQL-Disaster-Recovery-With-Barman" https://github.com/softwarebrahma/PostgreSQL-Disaster-Recove... :

    > The solution architecture chosen here is a 'Traditional backup with WAL streaming' architecture implementation (Backup via rsync/SSH + WAL streaming). This is chosen as it provides incremental backup/restore & a bunch of other features.

    Glossary of backup terms: https://en.wikipedia.org/wiki/Glossary_of_backup_terms

    Continuous Data Protection > Continuous vs near continuous:

  • > The database will then start replaying the WAL files. It's progress can be tracked through the log files at /var/log/postgresql/.

    - "PostgreSQL-Disaster-Recovery-With-Barman" https://github.com/softwarebrahma/PostgreSQL-Disaster-Recove... :

    > The solution architecture chosen here is a 'Traditional backup with WAL streaming' architecture implementation (Backup via rsync/SSH + WAL streaming). This is chosen as it provides incremental backup/restore & a bunch of other features.

    Glossary of backup terms: https://en.wikipedia.org/wiki/Glossary_of_backup_terms

    Continuous Data Protection > Continuous vs near continuous:

  • Redash

    Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.

    Yeah, a lot of the time I'd agree with you.

    This container came about for the Redash project (https://github.com/getredash/redash), which has been stuck on PostgreSQL 9.5 (!) for years.

    Moving to a new PostgreSQL container version is easy enough for new installations, but rolling that kind of change out to an existing userbase isn't so pretty.

    For people familiar with the command line, PostgreSQL, and Docker then no worries.

    But a large number of Redash deployments seem to have been done by people not skilled in those things. "We deployed it from the Digital Ocean droplet / AWS image / etc!"

    For those situations, something that takes care of the database upgrade process automatically is the better approach. :)

  • InfluxDB

    Collect and Analyze Billions of Data Points in Real Time. Manage all types of time series data in a single, purpose-built database. Run at any scale in any environment in the cloud, on-premises, or at the edge.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts