Skip to main content

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


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)

Uploaded Source

Built Distribution

pg_logidater-0.3.5-py3-none-any.whl (25.0 kB view details)

Uploaded Python 3

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

Hashes for pg_logidater-0.3.5.tar.gz
Algorithm Hash digest
SHA256 78c6751a4883a1892698bf1d05285df0be47e7c7132a5e5506438eef6658b0da
MD5 abb36ee616e4286dbd6ebba9fa6b8b59
BLAKE2b-256 6b422025b30a7116ff58c9c1c75ee09c32e8b646ae89f1cd33dbc7250a0d5d83

See more details on using hashes here.

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

Hashes for pg_logidater-0.3.5-py3-none-any.whl
Algorithm Hash digest
SHA256 2155032a8711afd94afa52ed699dcaec7a74e9bc60cea087d8b8014c3a75b47d
MD5 c6e7b14b5cdb62cf45aa531b87fcd0a8
BLAKE2b-256 fdf26958c4c85776efe8481d02857a42d0d84b74f836801456e596246a91659c

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page