psql and passwords - Mailing list pgsql-general

From Michael Devogelaere
Subject psql and passwords
Date
Msg-id 1018888879.19603.17.camel@cobra.intern.mind.be
Whole thread Raw
Responses Re: psql and passwords  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

I've recently installed a beta-release of RedHat which ships PostgreSQL
7.2.1 and have troubles with using psql in non-interactive scripts.

With the previous version, i passed the password with
 'echo pass | psql -d db -U user -h server -c "..."'
but that doesn't seem to work anymore (because it reads the password now
from /dev/tty instead of stdin i guess).

Is this a RedHat-specific issue or is it more general ? And of course:
what's the solution ? ;)


Kind regards,
Michael Devogelaere.






pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query planner quirk?
Next
From: "mike"
Date:
Subject: Re: Scaling postgres