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.3.4.tar.gz
(22.6 kB
view details)
Built Distribution
File details
Details for the file pg_logidater-0.3.4.tar.gz.
File metadata
- Download URL: pg_logidater-0.3.4.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 | 4d3cf9ced04141f9ac678ac7a1fc2509ec59e0dd06b9c6cf4f4a8f60b0ea8252 |
|
| MD5 | 19a6c5d8aebd8ace76bbd28640904abf |
|
| BLAKE2b-256 | 3926ab7bd8c308b3868a31c8fb7de350a7c8d5aa00093edbd61f0248ef330d30 |
File details
Details for the file pg_logidater-0.3.4-py3-none-any.whl.
File metadata
- Download URL: pg_logidater-0.3.4-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 | 968f38be5b318861c84c8a2a688d18861a5522b35405dccc7e106fdf44a6935c |
|
| MD5 | 3b967d8b33a09e1dda52a146a0ca6c86 |
|
| BLAKE2b-256 | 7a0559928b34189f3a39d1c437f4cc503d50a7046751ce4946dfb90878fdafa9 |
