[Fab-user] Potential Bug with calling psql (postgres command line)

[Jorge Vargas]

Hi,

So today I was writing some code to execute psql statements, and I
found the following.

with the following function:

def postgre_test():
    sudo('psql -U postgres')

I get

$ fab postgre_test -u jorge
No hosts found. Please specify (single) host string for connection: *****
[*****] sudo: psql -U postgres
Password:
[*****] err: /bin/bash: psql: command not found

Fatal error: sudo() encountered an error (return code 127) while
executing 'psql -U postgres'

Aborting.
Disconnecting from *****... done.


doing the same thing from the CLI I get the proper password dialog

address@hidden ~]# psql -U postgres
Password for user postgres:

I assume the problem is that that password prompt is psql, so fabric
has no way of knowing about it.

So my question is how can I get this to work?