None

[hawk@…]

runshell in db/backends/postgresql/client.py passes an argument like "-h somehost" to psql. That doesn't work with my psql binary (7.4.13 from Debian unstable); psql takes the space as part of the host name.

I changed the logic to produce argument lists like this:
['-U', 'someuser', '-W', '-h', 'somehost', 'somedb']
instead of this:
['-U someuser', '-W', '-h somehost', 'somedb']

Also, the code inserts a -W option (prompt for password) when a password is configured, not when there isn't. I inverted that logic.

[Malcolm Tredinnick]

The current logic is correct as regards -W: since there is no way to pass the password on the command line to psql, we can at least prompt the user for it when we know a password is going to be required.

Also, we do not want to use -W when there is no password required, because it *always* prompts for a password, before talking to the server and that will be annoying and confusing when the user has already set things up to indicate no password is required.

[anonymous]

Heh, I just came back to correct myself on the -W thing, but you beat me to it. Don't know what I was thinking on that one.

[Malcolm Tredinnick]

(In [3278]) Fixed #2278 -- Fixed some argument parsing problems with the PostgreSQL
dbshell. Also added in the process name to the arg list so that the output of
'ps' looks sensible.

[anonymous]

semi truck driving jobs truck driving jobs in ohio