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.1.0.tar.gz
(21.5 kB
view details)
Built Distribution
File details
Details for the file pg_logidater-0.1.0.tar.gz.
File metadata
- Download URL: pg_logidater-0.1.0.tar.gz
- Upload date:
- Size: 21.5 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 | 44ac2ffa7b789c0534f9153acf49aaf958df080774dbdf57e96c2e8bcacea220 |
|
| MD5 | fa8c401e7538ee31f6c23aac639bcfeb |
|
| BLAKE2b-256 | 67acfb268f4f0dc2473f5174c467bee9f1435044eca60bdf30127400ada19130 |
File details
Details for the file pg_logidater-0.1.0-py3-none-any.whl.
File metadata
- Download URL: pg_logidater-0.1.0-py3-none-any.whl
- Upload date:
- Size: 23.9 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 | 69589a23a592172c8a9f80751c30666d6b73550b7e766bc00f7be21d169b0145 |
|
| MD5 | c2c1e4239274fc4e215ea172a84ea2c6 |
|
| BLAKE2b-256 | bb9903ce3d5141cb9d96dcc8c871d836e8b669ecf2afc5972c8254b6686b1e4d |
