Dump Postgres Roles and Grants
Project description
Dump Postgres Roles and Grants
Install
pipx
pipx install dump-psql-roles-grants
dump-psql-roles-grants --help
pip
pip install dump-psql-roles-grants
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.3.0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6dce0239f01a9a0bc1456dde54626ccb19df34a122362ed11955a6c4ed5310a1 |
|
MD5 | 4905cc842571e937fc5c3d905b307f79 |
|
BLAKE2b-256 | 79d7b5026a9e4372930a2806454facbce2994a36115e5e1bbd736acc22e0a5de |
Close
Hashes for dump_psql_roles_grants-0.3.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | eb09c9ed9db740fe3d5d7cd570fb080837fbe66bc9549329484a5cf468d7be36 |
|
MD5 | a579aecf6455326cbe3704dd32b0ffa5 |
|
BLAKE2b-256 | e6f53b8e348a241e9c2e79a166ecf00dae3c96c73e2c722efc4f1719a624ebf0 |