On Nov 5, 2008, at 9:59 AM, Laurent Wandrebeck wrote:
> 2008/11/5 Brandon Metcalf <bmetcalf@nortel.com>:
>> We have a number of automated jobs that connect to our pgsql DB and
>> I'm wondering what others are doing for authentication and securing
>> passwords. It's easy enough to hardcode a password, but is there
>> something specific to pgsql, perhaps, that would be a better
>> solution?
>
> http://www.postgresql.org/docs/8.3/interactive/libpq-pgpass.html may
> do the trick.
ident authentication can be a good alternative for scheduled jobs
running
on the same machine as the database too.
Cheers,
Steve