D Unit wrote:
I've used Postgres on Linux for several years, and I have relied on the
'ident' authentication method for system administration and other tasks. Now
I need to get a postgres database up and running on Solaris. The problem is
that 'ident' authentication is not supported on Solaris. I can't figure out
how to do simple things, such as running pg_dumpall from a cron job, because
without 'ident' authentication the dump script prompts for a password.
Does anybody have a work around for this problem?
Check the manuals for mention of the ".pgpass" file - it's in the libpq
section iirc.
--
Richard Huxton
Archonet Ltd
