Re: Docs for service file - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: Docs for service file
Date
Msg-id 200301092152.h09LqhI14349@candle.pha.pa.us
Whole thread Raw
In response to Re: Docs for service file  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Docs for service file
List pgsql-patches
Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > Tom Lane wrote:
> > > Rather than documenting it and thereby locking ourselves into a
> > > misdesigned "feature", I'd vote for removing code and docs too.
> > > We can put the concept on the TODO-for-protocol-change list instead.
> >
> > Other votes?
>
> I'm still looking for a reason to use this feature.  Clearly, as it stands
> it is only single-host.  And on a single host you can use the environment
> variables.  Also, any reasonable application provides its own way to
> encapsulate database connection information.  And the other emails don't
> convince me at all that this is somehow "Oracle-compatible".
>
> Maybe you want to use ODBC, which gives you something like this and much
> more.

Joe Conway says he uses this exact feature in Oracle.  They just
distribute the file to the hosts.  That seemed like a good reason to
keep it.  Obviously the original patch submitter liked it too.  I think
the nice thing was that you can just call the service name and get some
params.  It seems better to do that than try to switch to the proper
environment variables before starting the app.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: more adequate usage msg: pg_controldata.diff
Next
From: Tom Lane
Date:
Subject: Re: more adequate usage msg: pg_controldata.diff