This documentation applies to the latest version of hitchpostgres.

HitchPostgres is a Hitch Plugin created to make testing applications that use Postgresql easier.

It contains:

  • A Hitch Package to download and install specified version(s) of postgresql.
  • A Service to set up a test-specific postgresql environment and run postgresql.

Note: the postgresql service destroys and sets up a new database during each test run in order to provide Isolation for your tests.


First, install the the plugin in your tests directory:

$ hitch install hitchpostgres

Set up postgres

In your test, define the version of postgres that you want to test with:

import hitchpostgres

postgres_package = hitchpostgres.PostgresPackage(
    version="9.3.9"  # Optional (default is the latest version of postgres)

# Downloads & installs Postgres to ~/.hitchpkg if not already installed by previous test

To use, define the service after initializing the Service Bundle but before starting it:


See also: Generic Service API

# Define a postgresql user for your service to set up
postgres_user = hitchpostgres.PostgresUser("newpguser", "pguserpassword")

# Define a postgresql database for your service to set up
postgres_database = hitchpostgres.PostgresDatabase(
    name="databasename",                  # Mandatory
    owner=postgres_user,                  # Mandatory
    dump="dumps/yourdump.sql"             # Optional (default: create empty database)

self.services['Postgres'] = hitchpostgres.PostgresService(
    postgres_package=postgres_package,    # Mandatory
    port=15432,                           # Optional (default: 15432)
    users=[postgres_user, ],              # Optional (default: no users)
    databases=[postgres_database, ]       # Optional (default: no databases)
    encoding='UTF-8',                     # Optional (default: UTF-8)
    locale='en_US'                        # Optional (default: en_US)
    pgdata=None,                          # Optional location for pgdata dir (default: put in .hitch)

Interacting with Postgres

Once it is running, you can interact with the service and its databases:

In [1]: self.services['Postgres'].databases[0].psql("-c", "SELECT * FROM yourtable;").run()
[ Prints output ]

In [2]: self.services['Postgres'].databases[0].psql().run()
[ Launches into postgres shell ]