Skip to main content

Command line utility to tunnel a PostgreSQL connection

Project description

Gotthard is a command line tool to simplify connecting to a PostgreSQL instance via a bastion host. This tool is created in the context of zalando-stups, however it could be used without it.


$ sudo pip3 install --upgrade gotthard


Gotthard does not have its own configuration. It uses the piu configuration file.


Gotthard can provide help with the commands itself:

$ gotthard --help

Gotthard can run in two basic modes: in the foreground and in the background.

When running in the background, gotthard establishes a tunnel and keeps the tunnel running in the background.

$ gotthard

When running in the foreground, the tunnel is established and the command you specify is executed. Once your command finishes, the tunnel is closed. If you need to pass options to the command, you will have to add the -- to signify that the following options should not be interpreted by gotthard.

$ gotthard psql
$ gotthard -- psql -U myusername

Stups: Requesting access to odd

When using even & odd, the command will only succeed if you have been granted access to the odd host you are trying to connect to. You can request access manually, but you can also have gotthard take care of this. When specifying a reason, gotthard will actually execute a piu request-access for you.

$ gotthard --reason="Investigating INCIDENT-123" psql

Connecting to a local Spilo

If you want to connect to a Spilo that is running in the same network as your odd-host, you can use the name of the Spilo appliance to connect. This does however require you to be logged in to your AWS account, as we need to query your account.

$ gotthard shippinglogistics psql

How does it actually work

The way Gotthard works is by setting up an ssh tunnel to the bastion host. It chooses the local port specified a free local port to tunnel the requests to remote side to port 5432.

When running in the background, it’s task is done: It will report back the details of the tunnel.

When running in the foregroed, Gotthard will export the PostgreSQL related Environment Variables to the process it needs to run. Most PostgreSQL client tools will use these environment variables to connect, most of your python or perl scripts should adhere to these variables as well.

$ gotthard shippinglogistics env | grep PG


Export a database

$ gotthard --reason="FEATURE-123" -- pg_dump -d fancydb -Fc -f fancydb.dump

Get the size of an RDS database

$ query="SELECT pg_database_size(CURRENT_CATALOG)"
$ gotthard -- psql -U rds_admin -d featuredb -c "$query"

Duplicate a Spilo database to your machine

This actually requires you to have replication privileges.

$ gotthard shippinglogistics -- pg_basebackup -D /postgres/mydata

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for gotthard, version 1.11
Filename, size File type Python version Upload date Hashes
Filename, size gotthard-1.11-py3-none-any.whl (11.0 kB) File type Wheel Python version 3.6 Upload date Hashes View
Filename, size gotthard-1.11.tar.gz (8.9 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page