Skip to main content

PostgreSQL Upgrades Manager (PUM)

logo

New version

This is the code of pum version 1. You can find version 0.x documentation at https://github.com/opengisch/pum/tree/old-v1

About

PUM (PostgreSQL Upgrades Manager) is a robust database migration management tool designed to streamline the process of managing PostgreSQL database upgrades. Inspired by tools like FlywayDB and Liquibase, PUM leverages metadata tables to ensure seamless database versioning and migration.

Key Features

  • Flexible Database Connections: Connect using PostgreSQL service names or direct connection strings (URI or parameters).
  • Command-line and Python Integration: Use PUM as a standalone CLI tool or integrate it into your Python project.
  • Database Versioning: Automatically manage database versioning with a metadata table.
  • Changelog Management: Apply and track SQL delta files for database upgrades.
  • Droppable & recreatable app with data isolation: PUM supports a clean rebuild workflow where an application environment can be dropped and recreated deterministically using hooks (pre and post migration).

Why PUM?

Managing database migrations in a Version Control System (VCS) can be challenging, especially for production databases. PUM simplifies this process by embedding version metadata directly into the database, enabling efficient tracking and application of migrations.

PUM was developed to address challenges in the TEKSI project, an open-source GIS for network management based on QGIS.

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pum-1.8.0.tar.gz (97.5 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

pum-1.8.0-py3-none-any.whl (77.1 kB view details)

Uploaded Python 3

File details

Details for the file pum-1.8.0.tar.gz.

File metadata

  • Download URL: pum-1.8.0.tar.gz
  • Upload date:
  • Size: 97.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.12

File hashes

Hashes for pum-1.8.0.tar.gz
Algorithm Hash digest
SHA256 05c4e44bea8194417470b6d92e57fdc5ade72762ba9745f264b26e457bea2eb3
MD5 ea168e938d4234c527eb83a44dcc02e3
BLAKE2b-256 1a7a11cdb709c89f4e236adc25146ef1c232552441b1dec3905aeca585af3243

See more details on using hashes here.

Provenance

The following attestation bundles were made for pum-1.8.0.tar.gz:

Publisher: deploy-to-pypi.yml on opengisch/pum

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file pum-1.8.0-py3-none-any.whl.

File metadata

  • Download URL: pum-1.8.0-py3-none-any.whl
  • Upload date:
  • Size: 77.1 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.12

File hashes

Hashes for pum-1.8.0-py3-none-any.whl
Algorithm Hash digest
SHA256 218af52efb917894cb4a9120c71d95559414c617b6a30bae782eaa6d5ede9a20
MD5 6142e7985ba30eb6a05de178bd341308
BLAKE2b-256 876251208ea7b23e66723629b17aec7d70123d22da638250e514f52b13843045

See more details on using hashes here.

Provenance

The following attestation bundles were made for pum-1.8.0-py3-none-any.whl:

Publisher: deploy-to-pypi.yml on opengisch/pum

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Release history Release notifications | RSS feed

This release

1.8.0

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page