# Dump Postgres Roles and Grants
## Install
You can choose
- plain python package `dump-psql-roles-grants` that requires `libpq` system library
- or package `dump-psql-roles-grants[binary]` that have binaries included
### pipx (preferred)
```shell
pipx install 'dump-psql-roles-grants[binary]'
dump_psql_roles_grants --help
```
### brew
```shell
brew install rgeraskin/homebrew/dump-psql-roles-grants
dump_psql_roles_grants --help
```
### pip
```shell
pip install 'dump-psql-roles-grants[binary]'
python -m dump_psql_roles_grants --help
```
### docker
```shell
docker pull rgeraskin/dump_psql_roles_grants
docker run --name dump_psql_roles_grants --rm rgeraskin/dump_psql_roles_grants --help
```
## Usage
1. Generate an example config file `dump_psql_roles_grants gen-example-config -o config.yaml`
1. Place instances connection info to `_inputs` dir
```shell
_inputs/
├── dev.yaml
├── prod.yaml
├── stage.yaml
└── test.yaml
```
File format: yaml or json
```yaml
<INSTANCE NAME 1>:
dbname: <DB TO CONNECT>
host: <INSTANCE HOSTNAME>
password: <PASSWORD>
user: <USER NAME>
<INSTANCE NAME X>:
dbname: <DB TO CONNECT>
host: <INSTANCE HOSTNAME>
password: <PASSWORD>
user: <USER NAME>
```
1. Review `config.yaml`
1. Run
```shell
dump_psql_roles_grants --help
```
Raw data
{
"_id": null,
"home_page": "https://github.com/rgeraskin/dump_psql_roles_grants",
"name": "dump-psql-roles-grants",
"maintainer": null,
"docs_url": null,
"requires_python": "<4.0,>=3.12",
"maintainer_email": null,
"keywords": "postgres, psql, roles, grants, dump",
"author": "Roman Geraskin",
"author_email": "roman.n.geraskin@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/02/12/4b600dba2d3721faae5695346f16e2e53906514de6078795115b20e22f55/dump_psql_roles_grants-0.3.1.tar.gz",
"platform": null,
"description": "# Dump Postgres Roles and Grants\n\n## Install\n\nYou can choose\n\n- plain python package `dump-psql-roles-grants` that requires `libpq` system library\n- or package `dump-psql-roles-grants[binary]` that have binaries included\n\n### pipx (preferred)\n\n```shell\npipx install 'dump-psql-roles-grants[binary]'\ndump_psql_roles_grants --help\n```\n\n### brew\n\n```shell\nbrew install rgeraskin/homebrew/dump-psql-roles-grants\ndump_psql_roles_grants --help\n```\n\n### pip\n\n```shell\npip install 'dump-psql-roles-grants[binary]'\npython -m dump_psql_roles_grants --help\n```\n\n### docker\n\n```shell\ndocker pull rgeraskin/dump_psql_roles_grants\ndocker run --name dump_psql_roles_grants --rm rgeraskin/dump_psql_roles_grants --help\n```\n\n## Usage\n\n1. Generate an example config file `dump_psql_roles_grants gen-example-config -o config.yaml`\n1. Place instances connection info to `_inputs` dir\n\n ```shell\n _inputs/\n \u251c\u2500\u2500 dev.yaml\n \u251c\u2500\u2500 prod.yaml\n \u251c\u2500\u2500 stage.yaml\n \u2514\u2500\u2500 test.yaml\n ```\n\n File format: yaml or json\n\n ```yaml\n <INSTANCE NAME 1>:\n dbname: <DB TO CONNECT>\n host: <INSTANCE HOSTNAME>\n password: <PASSWORD>\n user: <USER NAME>\n\n <INSTANCE NAME X>:\n dbname: <DB TO CONNECT>\n host: <INSTANCE HOSTNAME>\n password: <PASSWORD>\n user: <USER NAME>\n ```\n\n1. Review `config.yaml`\n\n1. Run\n\n ```shell\n dump_psql_roles_grants --help\n ```\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "Dump Postgres Roles and Grants",
"version": "0.3.1",
"project_urls": {
"Homepage": "https://github.com/rgeraskin/dump_psql_roles_grants",
"Repository": "https://github.com/rgeraskin/dump_psql_roles_grants"
},
"split_keywords": [
"postgres",
" psql",
" roles",
" grants",
" dump"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "a1523b02217920c9309a3036fa8e85de3fa17953e17912aedf690b759bd4bbba",
"md5": "ff4783d2ebc4afc7622a91dd99225f30",
"sha256": "ca8a20b0cee250a5ee47f89e0c98c3e52b87567df1a03a2f68aa5c67c13ab4bc"
},
"downloads": -1,
"filename": "dump_psql_roles_grants-0.3.1-py3-none-any.whl",
"has_sig": false,
"md5_digest": "ff4783d2ebc4afc7622a91dd99225f30",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": "<4.0,>=3.12",
"size": 10223,
"upload_time": "2024-04-09T22:58:58",
"upload_time_iso_8601": "2024-04-09T22:58:58.503026Z",
"url": "https://files.pythonhosted.org/packages/a1/52/3b02217920c9309a3036fa8e85de3fa17953e17912aedf690b759bd4bbba/dump_psql_roles_grants-0.3.1-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "02124b600dba2d3721faae5695346f16e2e53906514de6078795115b20e22f55",
"md5": "23bd69f77ca96e6e19d174ad340be52e",
"sha256": "0aa661a9e3783ed06d407c5a45f8ff1245d9be27d09c232170e17373a96a3f44"
},
"downloads": -1,
"filename": "dump_psql_roles_grants-0.3.1.tar.gz",
"has_sig": false,
"md5_digest": "23bd69f77ca96e6e19d174ad340be52e",
"packagetype": "sdist",
"python_version": "source",
"requires_python": "<4.0,>=3.12",
"size": 8104,
"upload_time": "2024-04-09T22:59:01",
"upload_time_iso_8601": "2024-04-09T22:59:01.691461Z",
"url": "https://files.pythonhosted.org/packages/02/12/4b600dba2d3721faae5695346f16e2e53906514de6078795115b20e22f55/dump_psql_roles_grants-0.3.1.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-04-09 22:59:01",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "rgeraskin",
"github_project": "dump_psql_roles_grants",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "dump-psql-roles-grants"
}
JSON
