/pgtoolkit

Manage Postgres cluster files from Python

Primary LanguagePythonPostgreSQL LicensePostgreSQL

Postgres Cluster Support in Python

Continuous Integration report Code coverage report Documentation

pgtoolkit provides implementations to manage various file formats in Postgres cluster. Currently:

  • postgresql.conf: read, edit, save.
  • pg_hba.conf: render, validate and align columns.
  • .pgpass: render, validate and sort lines.
  • pg_service.conf: find, read, edit, render.
  • Cluster logs.

It also provides a Python API for calling pg_ctl commands.

import sys

from pgtoolkit.hba import parse


with open('pg_hba.conf') as fo:
    hba = parse(fo)

hba.write(sys.stdout)

The API in this toolkit must:

  • Use only Python stdlib.
  • Use Postgres idioms.
  • Have full test coverage.
  • Run everywhere.

Support

pgtoolkit home on GitHub is the unique way of interacting with developers. Feel free to open an issue to get support.