Re: Patch for TNS services - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Patch for TNS services
Date
Msg-id 200010170101.VAA26772@candle.pha.pa.us
Whole thread Raw
In response to Re: Patch for TNS services  (Mario Weilguni <mweilguni@sime.com>)
List pgsql-hackers
Patch applied.  Can you send me the SGML diff?  I will merge them in.


> I've now prepared a polished and clean patch vs. 7.0.2. Who's gonna integrate 
> this patch in the CVS? I've no CVS access.
> 
> The docs are another problem. I've installed jade and most other SGML stuff 
> here, but "make user.html" fails with errors like :
> 
> jade:user.sgml:5:55:W: cannot generate system identifier for public text 
> "-//OASIS//DTD Dojade:user.sgml:41:0:E: reference to entity "BOOK" for which 
> no system identifier could be
> jade:user.sgml:5:0: entity was defined here
> jade:user.sgml:41:0:E: DTD did not contain element declaration for document 
> type name 
> 
> The patch is included as attachement (159 lines).
> 
> 
> The patch is included
> 
> Am Tue, 12 Sep 2000 schrieben Sie:
> > Sounds like people want it.  Can you polish it off, add SGML docs and
> > send it over?
> >
> > > -----BEGIN PGP SIGNED MESSAGE-----
> > >
> > > Last week I created a patch for the Postgres client side libraries to
> > > allow something like a (not so mighty) form of Oracle TNS, but nobody
> > > showed any interest. Currently, the patch is not perfect yet, but works
> > > fine for us. I want to avoid improving the patch if there is no interest
> > > in it, so if you think it might be a worthy improvement please drop me a
> > > line.
> > >
> > > It works like this:
> > > The patch allows to supply another parameter to the Postgres connect
> > > string, called "service". So, instead of having a connect string (e.g. in
> > > PHP) like "dbname=foo host=bar port=5433 user=foouser password=barpass"
> > > the string would be
> > > "service=stupid_name_here"
> > > or more often
> > > "service=stupid_name_here user=foouser password=barpass"
> > >
> > > There's a config file /etc/pg_service.conf, having an entry like:
> > > [stupid_name_here]
> > > dbname=foo
> > > host=bar
> > > port=5433
> > > ....
> > >
> > > The advantage is you can go from one database host, database, port or
> > > whatever without having to touch the scripts or applications. We're
> > > currently in the process of migrating all of our PHP and Python scripts
> > > to another from localhost, port 5433 to another machine, port 5432 and
> > > it's not something I ever want to do again, I'd to change around 100
> > > files and I'm still not sure if I've missed one.
> > >
> > > The patch is client-side only, around 100 lines, needs no changes to the
> > > backend and is compatible with all applications supplying a connection
> > > string (not using PQsetdblogin)
> > >
> > > - --
> > > Why is it always Segmentation's fault?
> > > -----BEGIN PGP SIGNATURE-----
> > > Version: 2.6.3i
> > > Charset: noconv
> > >
> > > iQCVAwUBOa1MsQotfkegMgnVAQEIsAP+Na72pNdT+RoQcjuX5cn1TKkPlNAh9BV5
> > > kCNP+Zui6WfZSiA8RYPuruXF0QyEMPZZD6AI9Wqr5sQ75kVSb65uOt9rLrdS0bxA
> > > WTClNjlLKG3Rk1IGSFBm+C0p8lcA3AYTohHLhHB3q+WeLTneI5lJfwpo2AWyinQt
> > > 0k/1r6EwpUk=
> > > =+skX
> > > -----END PGP SIGNATURE-----
> >
> > [ Attachment, skipping... ]
> 
[ Attachment, skipping... ]


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: RE: AW: Backup, restore & pg_dump
Next
From: The Hermit Hacker
Date:
Subject: Re: The lightbulb just went on...