Using local psql to connect to DB? about dokku-postgres HOT 4 CLOSED

If you want to use a different psql command, you're going to have to do that on your own. Our goal with the official plugins is to push as much of the functionality as possible into docker container calls.

Is there a reason the limitations cannot be worked around with the existing call?

from dokku-postgres.

I think the limitations are actually Docker tty limitations, so not sure if they can be worked around.

from dokku-postgres.

If you need a more enhanced postgres client, I would suggest using a local psql or other and running postgres:expose on your postgres database.

from dokku-postgres.

A quick dirty workaround in case someone is interested:

#!/bin/bash

NAME=$1
IP=`docker inspect dokku.postgres.$NAME | python -c 'import json,sys;obj=json.load(sys.stdin);print obj[0]["NetworkSettings"]["Networks"]["bridge"]["IPAddress"]'`
DATABASE_URL=`dokku config:get $NAME DATABASE_URL`
USERNAME=`echo $DATABASE_URL | sed "s/[a-z]*:\/\/\([a-zA-Z0-9]*\):.*/\1/"`
PASSWORD=`echo $DATABASE_URL | sed "s/[a-z]*:\/\/[a-zA-Z0-9]*:\([a-z0-9]*\)@.*/\1/"`
PORT=`echo $DATABASE_URL | sed "s/[a-z]*:\/\/[a-zA-Z0-9]*:[a-z0-9]*@.*:\([0-9]*\)\/.*/\1/"`
DATABASE=`echo $DATABASE_URL | sed "s/[a-z]*:\/\/[a-zA-Z0-9]*:[a-z0-9]*@.*:[0-9]*\/\(.*\)/\1/"`

PGPASSWORD=$PASSWORD /usr/bin/psql -h $IP -p $PORT -U $USERNAME $DATABASE

Requires psql to be installed on host machine.

from dokku-postgres.