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
```
Raw data
{
"_id": null,
"home_page": "https://github.com/niekosau",
"name": "pg-logidater",
"maintainer": null,
"docs_url": null,
"requires_python": "<3.10,>=3.9",
"maintainer_email": null,
"keywords": "postgres",
"author": "Arunas Grigalionis",
"author_email": "arunas.grigalionis@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/39/26/ab7bd8c308b3868a31c8fb7de350a7c8d5aa00093edbd61f0248ef330d30/pg_logidater-0.3.4.tar.gz",
"platform": null,
"description": "pg-logidater\n============\n> [!CAUTION]\n> Use with yout own risk, not batletested\n\nPostgreSQL logical replication setup utility.\nMust be executed on target host.\n\n## Requirements:\n* Must be executed with root or user must have setuid/setgid capabilities\n* User must have ability to connect to replica host using ssh key (no password accepted)\n* .pagpass containing all needed passwords if required\n* postgresql installed and running\n\n## Examples\n```\npg-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\npg-logidater --saved-conf setup-replica\npg-logidater --saved-conf sync-sequences\npg-logidater --saved-conf remove-repl-config\n```\n\nClean up target host:\n```\npg-logidater --saved-conf drop-setup\n```\n",
"bugtrack_url": null,
"license": "GPL-3.0-only",
"summary": "Postgresql logical replication setup utility",
"version": "0.3.4",
"project_urls": {
"Homepage": "https://github.com/niekosau",
"Repository": "https://github.com/niekosau/pg-logidater"
},
"split_keywords": [
"postgres"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "7a0559928b34189f3a39d1c437f4cc503d50a7046751ce4946dfb90878fdafa9",
"md5": "3b967d8b33a09e1dda52a146a0ca6c86",
"sha256": "968f38be5b318861c84c8a2a688d18861a5522b35405dccc7e106fdf44a6935c"
},
"downloads": -1,
"filename": "pg_logidater-0.3.4-py3-none-any.whl",
"has_sig": false,
"md5_digest": "3b967d8b33a09e1dda52a146a0ca6c86",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": "<3.10,>=3.9",
"size": 25014,
"upload_time": "2024-06-13T08:13:35",
"upload_time_iso_8601": "2024-06-13T08:13:35.883124Z",
"url": "https://files.pythonhosted.org/packages/7a/05/59928b34189f3a39d1c437f4cc503d50a7046751ce4946dfb90878fdafa9/pg_logidater-0.3.4-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "3926ab7bd8c308b3868a31c8fb7de350a7c8d5aa00093edbd61f0248ef330d30",
"md5": "19a6c5d8aebd8ace76bbd28640904abf",
"sha256": "4d3cf9ced04141f9ac678ac7a1fc2509ec59e0dd06b9c6cf4f4a8f60b0ea8252"
},
"downloads": -1,
"filename": "pg_logidater-0.3.4.tar.gz",
"has_sig": false,
"md5_digest": "19a6c5d8aebd8ace76bbd28640904abf",
"packagetype": "sdist",
"python_version": "source",
"requires_python": "<3.10,>=3.9",
"size": 22599,
"upload_time": "2024-06-13T08:13:37",
"upload_time_iso_8601": "2024-06-13T08:13:37.149631Z",
"url": "https://files.pythonhosted.org/packages/39/26/ab7bd8c308b3868a31c8fb7de350a7c8d5aa00093edbd61f0248ef330d30/pg_logidater-0.3.4.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-06-13 08:13:37",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "niekosau",
"github_project": "pg-logidater",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "pg-logidater"
}
JSON
