Обсуждение: storing passwords
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? Thanks. -- Brandon
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. Regards, Laurent.
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