Postgresql logical replication setup utility
Project description
pg-logidater
[!CAUTION] Use with yout own risk, not batletested
PostgreSQL logical replication setup utility. Must be executed on target host.
Requirements:
- Must be executed with root or user must have setuid/setgid capabilities
- User must have ability to connect to replica host using ssh key (no password accepted)
- .pagpass containing all needed passwords if required
- postgresql installed and running
Examples
pg-logidater --database db_name --master-host 127.0.0.1 --replica-host 127.0.0.2 --psql-user super_user --repl-name name_for_pub_sub_repl save-cli-options
pg-logidater --saved-conf setup-replica
pg-logidater --saved-conf sync-sequences
pg-logidater --saved-conf remove-repl-config
Clean up target host:
pg-logidater --saved-conf drop-setup
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
pg_logidater-0.2.0.tar.gz
(22.1 kB
view details)
Built Distribution
File details
Details for the file pg_logidater-0.2.0.tar.gz.
File metadata
- Download URL: pg_logidater-0.2.0.tar.gz
- Upload date:
- Size: 22.1 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: poetry/1.8.2 CPython/3.9.19 Darwin/23.4.0
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | bb7cc685b7215f1d3134a5df84ecda6b2fbeda77920a24bd5d1f5d62fa459db6 |
|
| MD5 | 9b356769abdadc011af46845cc3e37eb |
|
| BLAKE2b-256 | 2aeb2b99b35e7b4e976dde0037e71f560954a3611cd230267e4deb99a18ecf32 |
File details
Details for the file pg_logidater-0.2.0-py3-none-any.whl.
File metadata
- Download URL: pg_logidater-0.2.0-py3-none-any.whl
- Upload date:
- Size: 24.5 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: poetry/1.8.2 CPython/3.9.19 Darwin/23.4.0
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | ab799e3892ff824d69d31e4d13f658a1cbb98bf32dfdff02ecc3017ef9f2ca24 |
|
| MD5 | 97a18145c7d74a79092f62c83ccf4878 |
|
| BLAKE2b-256 | e71850f380ad79393e6d3b5bd87ca5a2590eac89fb4252f130dc408ebeab2e9c |
