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