Cannot dump database through SSH about dokku-postgres HOT 7 CLOSED

@Flink thoughts here?

from dokku-postgres.

I need to do some tests but I never dumped (nor restored) in plain SQL with PG and I never had any problems. (and I migrated data from Heroku to “real” PG servers, to containers, etc., it always worked). It might be a problem on your machines or maybe with a certain version of PG, I don’t know.

@ebeigarts Did you try to dump/restore directly on the machine and not through ssh? (just an idea)

from dokku-postgres.

@Flink it works locally on the machine. ssh -t / RequestTTY yes was the problem and this is the way dokku recommends. Using ssh -T dokku@<host> -- postgres:export <app> works. Using plain SQL dumps this wasn't a problem. Maybe there should be a warning in the README about this?

from dokku-postgres.

Maybe the postgres:export command could check if it is running in a tty and print a warning to stderr?

$ ssh -T root@<host> 'echo $SSH_TTY'

$ ssh -t root@<host> 'echo $SSH_TTY'
/dev/pts/4
Connection to <host> closed.

from dokku-postgres.

I think I had a similar problem on https://github.com/Flink/dokku-psql-single-container, I’ll take a look about what you’re suggesting :)

from dokku-postgres.

#19 @Flink maybe related?

from dokku-postgres.

Maybe we need to check for the tty yeah, I don’t know. I’ll do some testing :)

from dokku-postgres.