Skip site navigation (1) Skip section navigation (2)

Re: Java .pgpass reader

From: Scott Langley <slangley(at)scharp(dot)org>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Java .pgpass reader
Date: 2010-06-16 21:35:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Hi Chris:

Would you be willing to share your code for this?

I'm still wanting to / planning to implement this for an individual JDBC 
connection as the Java process that will use it runs once a week as a 
cron job.

And to Radoslaw:

Your point about the relatively weak security of storing passwords in 
.pgpass files is well-taken.  But I'm neither the SysAdmin nor the DBA 
at where I work so I can't easily change policy.  However, we are at 
least required to change our database passwords on a regular basis.


Chris Browne wrote:
> slangley(at)scharp(dot)org (Scott Langley) writes:
>> Did anyone ever implement code in Java to read Postgres configuration
>> information from a user's .pgpass file - or a more general
>> pg_service.conf - as discussed in this thread back in 2006?
> We've done this; it turned out to be something to do not at the level
> of an individual connection, but rather in a connection pool
> implementation.
> That turns out to be not so useful as a "general" solution that would
> be included in the JDBC driver :-(.

In response to

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2010-06-17 05:40:23
Subject: Re: pljava and postgresql 8.4.4 compile errors
Previous:From: Radosław SmoguraDate: 2010-06-16 20:44:16
Subject: Re: Java .pgpass reader

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group