Postgres Pro
Downloads
Home   >   mailing lists

Thread: Solaris and Ident

Solaris and Ident

From
D Unit
Date:
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?
--
View this message in context: http://www.nabble.com/Solaris-and-Ident-tf3371429.html#a9381507
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Re: Solaris and Ident

From
Richard Huxton
Date:
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

Re: Solaris and Ident

From
D Unit
Date:
I can't get the .pgpass file working. I think the problem may have to do with
the fact that the user's home directory is '/'. Is there a way to specify a
different location for .pgpass other than '~/.pgpass'?



--
View this message in context: http://www.nabble.com/Solaris-and-Ident-tf3371429.html#a9400075
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Re: Solaris and Ident

From
Michael Fuhr
Date:
On Fri, Mar 09, 2007 at 10:29:46AM -0800, D Unit wrote:
> I can't get the .pgpass file working. I think the problem may have to do with
> the fact that the user's home directory is '/'. Is there a way to specify a
> different location for .pgpass other than '~/.pgpass'?

Set the PGPASSFILE environment variable.  Also, make sure group and
world have no permissions on the file.

http://www.postgresql.org/docs/8.2/interactive/libpq-pgpass.html
http://www.postgresql.org/docs/8.2/interactive/libpq-envars.html

--
Michael Fuhr