postgres-ddl 1.0

PostgreSQL metadata grabber and comparer

Description

PostgreSQL metadata (DDL) grabber and database schema diff

Dependencies

• Python 3
• psycopg2

Installation

pip install psycopg2-binary postgres-ddl

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,
    "new_line": "\n",
    "indent": 2
}

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

• GitHub
• PyPI