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-Id....html#a9381507
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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-Id....html#a9400075
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

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/i...pq-pgpass.html
http://www.postgresql.org/docs/8.2/i...pq-envars.html

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly