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 (preferred)
pipx install 'dump-psql-roles-grants[binary]'
dump_psql_roles_grants --help
brew
brew install rgeraskin/homebrew/dump-psql-roles-grants
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.3.1.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0aa661a9e3783ed06d407c5a45f8ff1245d9be27d09c232170e17373a96a3f44 |
|
MD5 | 23bd69f77ca96e6e19d174ad340be52e |
|
BLAKE2b-256 | 02124b600dba2d3721faae5695346f16e2e53906514de6078795115b20e22f55 |
Close
Hashes for dump_psql_roles_grants-0.3.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ca8a20b0cee250a5ee47f89e0c98c3e52b87567df1a03a2f68aa5c67c13ab4bc |
|
MD5 | ff4783d2ebc4afc7622a91dd99225f30 |
|
BLAKE2b-256 | a1523b02217920c9309a3036fa8e85de3fa17953e17912aedf690b759bd4bbba |