Re: pg_service.conf ? - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: pg_service.conf ?
Date
Msg-id 7A9BE39D-B4B8-41C7-9183-BA47C3321192@fastcrypt.com
Whole thread Raw
In response to Re: pg_service.conf ?  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
On 14-Mar-06, at 10:52 AM, Oliver Jowett wrote:

> Christopher Browne wrote:
>
>> Note that libpq takes the perspective that pg_service.conf should
>> live
>> in the ../etc directory for the PostgreSQL build.  Thus, if psql is
>> living as /opt/dbs/pgsql825/bin/psql, then this would be in
>> /opt/dbs/pgsql825/etc/pg_service.conf.
>
> The big thing here is "how do we find the config file?". The JDBC
> driver has no concept of an "installation" .. it's just classes
> that the JVM manages to load somehow.

This is the biggest concern. In a case where a user runs a jdbc
client manually from the command line this is straight forward;
however it is quite problematic for drivers running in something like
a web application, or some other "container"

Practically speaking I don't have an issue implementing this, however
I can see this being a challenge managing the support for it. There
appears to be some ambiguity as to where the file is kept.
>
> -O
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: pg_service.conf ?
Next
From: "Brian Edwards"
Date:
Subject: subscribe