Skip to main content

A CLI tool used to manage Postgres data migrations from beginning to end, for a single database or a fleet, leveraging pglogical replication.

Project description

Pgbelt

Latest Commit

PgBelt is a CLI tool used to manage Postgres data migrations from beginning to end, for a single database or a fleet, leveraging pglogical replication.

It was built to assist in migrating data between postgres databases with as little application downtime as possible. It works in databases running different versions of postgres and makes it easy to run many migrations in parallel during a single downtime.

:exclamation: This is very important
As with all Data Migration tasks, there is a risk of data loss. Please ensure you have backed up your data before attempting any migrations

Installation

Install From PyPi

It is recommended to install pgbelt inside a virtual environment:

You must also have:

  • Postgres Client Tools (pg_dump, pg_restore). Mac: brew install libpq. Ubuntu: sudo apt-get install postgresql-client

Install pgbelt locally:

pip3 install pgbelt

Quickstart with Pgbelt

See this doc!

Playbook

This playbook gets updated actively. If you have any issues, solutions could be found in this playbook.

Contributing

We welcome contributions! See this doc on how to do so, including setting up your local development environment.

Project details


Download files

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

Source Distribution

pgbelt-0.7.8.tar.gz (34.5 kB view details)

Uploaded Source

Built Distribution

pgbelt-0.7.8-py3-none-any.whl (42.8 kB view details)

Uploaded Python 3

File details

Details for the file pgbelt-0.7.8.tar.gz.

File metadata

  • Download URL: pgbelt-0.7.8.tar.gz
  • Upload date:
  • Size: 34.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/5.1.1 CPython/3.12.5

File hashes

Hashes for pgbelt-0.7.8.tar.gz
Algorithm Hash digest
SHA256 9ded9423b47158dad9507debec9c7357a9d13984e66ba333d4737f4e8125dfaf
MD5 8129bf72508494c94905a4c79e0a99ce
BLAKE2b-256 ac833e11a00c616bb5de556280e399a3699fead45fbda23f1f3642cf255203b4

See more details on using hashes here.

File details

Details for the file pgbelt-0.7.8-py3-none-any.whl.

File metadata

  • Download URL: pgbelt-0.7.8-py3-none-any.whl
  • Upload date:
  • Size: 42.8 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/5.1.1 CPython/3.12.5

File hashes

Hashes for pgbelt-0.7.8-py3-none-any.whl
Algorithm Hash digest
SHA256 9797d5e142ed956a179e108179087406b91a0cc2f3845ef292101293655d1633
MD5 bcea69532f49f5bd790b351f7f101aad
BLAKE2b-256 d2c88cf38c27ba30849e82a50b46abf5cafb59795eb507aced7ce46b3c056d0b

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page