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.7.tar.gz (34.5 kB view details)

Uploaded Source

Built Distribution

pgbelt-0.7.7-py3-none-any.whl (42.9 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: pgbelt-0.7.7.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.7.tar.gz
Algorithm Hash digest
SHA256 9026e645ed22db87ba8d7a47a4a1b07d0c14c358a65b52cde05c7ef4ac8f4bb1
MD5 01b2b8427dd332df2e484217232af705
BLAKE2b-256 bca2b6c22137dbeb9f2129ac489868847a1affad63244485a51586dfdc62904f

See more details on using hashes here.

File details

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

File metadata

  • Download URL: pgbelt-0.7.7-py3-none-any.whl
  • Upload date:
  • Size: 42.9 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.7-py3-none-any.whl
Algorithm Hash digest
SHA256 2ef8fbce6b1a31c5af7af7208de1ddfbd770e56c53cce2248da2e8202208c976
MD5 9e84e9ac6c89220e76eccffe2d5d2105
BLAKE2b-256 dd11dbc7e67dcc3d09267f7112f9a48990c9b5e948ee0a79dae5f39b9b023143

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