Re: [GENERAL] pgpass (in)flexibility

2015-09-22 Thread Peter Eisentraut
On 9/15/15 1:48 AM, Ben Chobot wrote: > We're in a situation where we would like to take advantage of the pgpass > hostname field to determine which password gets used. For example: > > psql -h prod-server -d foo # should use the prod password > psql -h beta-server -d foo # should use the beta

Re: [GENERAL] pgpass (in)flexibility

2015-09-16 Thread Jim Nasby
On 9/15/15 10:32 AM, Ben Chobot wrote: On Sep 15, 2015, at 12:27 AM, Jim Nasby wrote: On 9/15/15 12:48 AM, Ben Chobot wrote: We're in a situation where we would like to take advantage of the pgpass hostname field to determine which password gets used. For example:

Re: [GENERAL] pgpass (in)flexibility

2015-09-15 Thread Jim Nasby
On 9/15/15 12:48 AM, Ben Chobot wrote: We're in a situation where we would like to take advantage of the pgpass hostname field to determine which password gets used. For example: psql -h prod-server -d foo # should use the prod password psql -h beta-server -d foo # should use the beta password

Re: [GENERAL] pgpass (in)flexibility

2015-09-15 Thread Ben Chobot
On Sep 15, 2015, at 12:27 AM, Jim Nasby wrote: > > On 9/15/15 12:48 AM, Ben Chobot wrote: >> We're in a situation where we would like to take advantage of the pgpass >> hostname field to determine which password gets used. For example: >> >> psql -h prod-server -d foo

[GENERAL] pgpass (in)flexibility

2015-09-14 Thread Ben Chobot
We're in a situation where we would like to take advantage of the pgpass hostname field to determine which password gets used. For example: psql -h prod-server -d foo # should use the prod password psql -h beta-server -d foo # should use the beta password This would *seem* to be simple, just