Dump Postgres Roles and Grants
Project description
Dump Postgres Roles and Grants
Install
You can choose
- plain python package
dump-psql-roles-grants
that requireslibpq
system library - or package
dump-psql-roles-grants[binary]
that have binaries included
pipx
pipx install 'dump-psql-roles-grants[binary]'
dump-psql-roles-grants --help
pip
pip install 'dump-psql-roles-grants[binary]'
python -m dump_psql_roles_grants --help
docker
docker pull rgeraskin/dump_psql_roles_grants
docker run --name dump_psql_roles_grants --rm rgeraskin/dump_psql_roles_grants --help
Usage
-
Generate an example config file
dump_psql_roles_grants gen-example-config -o config.yaml
-
Place instances connection info to
_inputs
dir_inputs/ ├── dev.yaml ├── prod.yaml ├── stage.yaml └── test.yaml
File format: yaml or json
<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>
-
Review
config.yaml
-
Run
dump_psql_roles_grants --help
Project details
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
Built Distribution
Close
Hashes for dump_psql_roles_grants-0.2.2.dev2.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4343e5af108608dd5c709af4d7b084f1e6980e9a8e47bf7ab2ac02db9a4025fd |
|
MD5 | 6f528afe6a8c78230f67a3360434ac9b |
|
BLAKE2b-256 | d0028ea11693d5af522156f7ed8f7bbde86e2e9e6ebea06dd418e1bb4bbb70d2 |
Close
Hashes for dump_psql_roles_grants-0.2.2.dev2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9a710f56d4b25dfe7b94b19b5001f5816f970fba99ae4fd162afdef3e66a7ca0 |
|
MD5 | 230a46b1e34e4ee4d4f86b191da62ead |
|
BLAKE2b-256 | c5b3addcd13d1d500004904d7fe53e242c1c3a492f3cdf999c9923c6733aa6c8 |