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

Re: Patch for TNS services

From: Mario Weilguni <mweilguni(at)sime(dot)com>
To: Postgres Hacker Lister <pgsql-hackers(at)postgresql(dot)org>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Subject: Re: Patch for TNS services
Date: 2000-09-22 16:05:00
Message-ID: 00092218050008.00875@linux (view raw or flat)
Thread:
Lists: pgsql-hackers
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: postgres-7.0-services.patch
Description: text/x-c (3.8 KB)

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2000-09-22 16:26:45
Subject: Re: [patch,rfc] binary operators on integers
Previous:From: Jeroen van VianenDate: 2000-09-22 15:34:53
Subject: Re: Patch for Bug in RI

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