PostgreSQL metadata grabber and comparer
Project description
Description
PostgreSQL metadata (DDL) grabber and database schema diff
Dependencies
Installation
pip install psycopg2-binary pg-metadata
Grabbing
1 ) Create config file with connection params and other settings:
{
"connect": {
"host": "localhost",
"port": 5432,
"database": "db",
"username": "some_user",
"password": "some_password"
},
"path": "/some/path/to/grabber/result/folder",
"exclude_schemas": [
"information_schema",
"pg_catalog"
],
"threads": 8
}
2 ) By default script opens config file config_grab.json
from the same directory as zzz_Grabber.py
file.
3 ) Alternatively you can specify path to config file as a first run parameter.
4 ) Run grabber:
# Run with default config (config_grab.json)
python "zzz_Grabber.py"
# Run with specified config file path
python "zzz_Grabber.py" "/some/path/to/config.json"
Compare (diff) databases
1 ) Create config file with connection params and other settings:
{
"source": {
"host": "localhost",
"port": 5432,
"database": "db_from",
"username": "user",
"password": "password"
},
"target": {
"host": "localhost",
"port": 5432,
"database": "db_to",
"username": "user",
"password": "password"
},
"path": "/some/path/to/compare/result/folder",
"exclude_schemas": [
"information_schema",
"pg_catalog"
]
}
2 ) By default script opens config file config_diff.json
from the same directory as zzz_Grabber.py
file.
3 ) Alternatively you can specify path to config file as a first run parameter.
4 ) Run diff:
# Run with default config (config_grab.json)
python "zzz_Diff.py"
# Run with specified config file path
python "zzz_Diff.py" "/some/path/to/config.json"
Links
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
pg_metadata-1.1.1.tar.gz
(17.9 kB
view hashes)
Built Distribution
Close
Hashes for pg_metadata-1.1.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 92a84dab0df9d9e58487b3e6c909aae0692a596a6537db9f10dfd66b3893ccee |
|
MD5 | dfdbcf9ed865b363ccacb8e587202c9e |
|
BLAKE2b-256 | e9f7dd535324a24fe91c10103f1332550dbbb6563a9a064b7c35067f5774a644 |