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
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.
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file pgbelt-0.12.1.tar.gz.
File metadata
- Download URL: pgbelt-0.12.1.tar.gz
- Upload date:
- Size: 44.1 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.1.0 CPython/3.12.8
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
ac40536962a87c20dde53d36bfadc8d03ffa2a9ce0e302602d14349a0d1af26c
|
|
| MD5 |
9665d79cd905135a354dfde40fc1ddf8
|
|
| BLAKE2b-256 |
984fd382e65774a35aedda55a75c7000cc0d0feebba870b83db5a27d8b1ce362
|
File details
Details for the file pgbelt-0.12.1-py3-none-any.whl.
File metadata
- Download URL: pgbelt-0.12.1-py3-none-any.whl
- Upload date:
- Size: 54.3 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.1.0 CPython/3.12.8
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
3a8b1c080cdc1aca5b72cb866b578864b4ab51535f93eeb0141eaeb8fdc8c48e
|
|
| MD5 |
59240bf18ad87f5fc1c491da45cd3eb8
|
|
| BLAKE2b-256 |
2244048f046db94e5a28dfad8b06af2fee1d271215a7e387c3040a46d6608348
|
