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.5.tar.gz
(22.6 kB
view details)
Built Distribution
File details
Details for the file pg_logidater-0.3.5.tar.gz
.
File metadata
- Download URL: pg_logidater-0.3.5.tar.gz
- Upload date:
- Size: 22.6 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: poetry/1.8.2 CPython/3.9.19 Darwin/23.5.0
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 78c6751a4883a1892698bf1d05285df0be47e7c7132a5e5506438eef6658b0da |
|
MD5 | abb36ee616e4286dbd6ebba9fa6b8b59 |
|
BLAKE2b-256 | 6b422025b30a7116ff58c9c1c75ee09c32e8b646ae89f1cd33dbc7250a0d5d83 |
File details
Details for the file pg_logidater-0.3.5-py3-none-any.whl
.
File metadata
- Download URL: pg_logidater-0.3.5-py3-none-any.whl
- Upload date:
- Size: 25.0 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: poetry/1.8.2 CPython/3.9.19 Darwin/23.5.0
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2155032a8711afd94afa52ed699dcaec7a74e9bc60cea087d8b8014c3a75b47d |
|
MD5 | c6e7b14b5cdb62cf45aa531b87fcd0a8 |
|
BLAKE2b-256 | fdf26958c4c85776efe8481d02857a42d0d84b74f836801456e596246a91659c |