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
Project details
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.3.1.tar.gz
(22.6 kB
view hashes)
Built Distribution
Close
Hashes for pg_logidater-0.3.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2e1a7425502d5bfa1ea587e8138eec47e24cb5d903f6efdbc1e533974661924c |
|
MD5 | acd638e440934fb22c518924589f3651 |
|
BLAKE2b-256 | 17ce9a991c2e065e17bb1657723db5cb8d0a1c6fa818ded9e8a5fd9b1efc723f |