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

From David Fetter
Subject Re: pg_service.conf ?
Date
Msg-id 20060314053058.GA10533@fetter.org
Whole thread Raw
In response to Re: pg_service.conf ?  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: pg_service.conf ?  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
On Mon, Mar 13, 2006 at 11:11:43PM -0500, Dave Cramer wrote:
> David,
>
> Can you give us the use case? How would you expect this to work ?

Let's imagine you have a pg_service.conf that says:

[foo]
host=foo.example.com
dbname=foo
port=5555
user=dcramer

[bar]
host=bar.example.com
dbname=bar
port=5554
user=dfetter

[baz]
host=baz.sample.com
dbname=baz
port=5553
user=brass_monkey

You'd use a connect string that looked something like

jdbc:postgresql://service=foo/

to get to the db called foo running foo.example.com on port 5555 as
ROLE (aka user) dcramer.  The pg_service.conf could then be
distributed around and available to every kind of application--even
ones not written in java.

Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 415 235 3778

Remember to vote!

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: pg_service.conf ?
Next
From: David Fetter
Date:
Subject: Re: pg_service.conf ?