Thread: TNS Services like Oracle?

TNS Services like Oracle?

From
Mario Weilguni
Date:
-----BEGIN PGP SIGNED MESSAGE-----

Hi!

I'm currently checking how difficult it would be to create something like 
Oracle TNS (I think that what it's called) service for the frontend library. 
The idea is:

1. Modify conninfo_parse() to accept parameters like "service=myservice"

2. e.g. you put as connection string "user=foo password=bar 
service=schlumpf", this will look into a special file (e.g. pg_services.conf) 
for a section like this:
[schlumpf]
host=194.121.121.121
port=5433
database=mydb
options=....

This will allow migration of database services much easier, especially if you 
have a lot of different applications (like at ISP's or ASP's), so when you 
change host, port or something like this, you won't have to touch 
applications (where faults are likely to occur).

Is something like this already possible in Postgres, or available with a 
patch?

- -- 
Why is it always Segmentation's fault?
-----BEGIN PGP SIGNATURE-----
Version: 2.6.3i
Charset: noconv

iQCVAwUBOaeI+wotfkegMgnVAQGZyAQAtBIOt3uk+fSq+otCuWQXSReh2evhwsaj
pDPCSe4OKFK6oIp65IIfgrLDxzmtBCl4xOI2A5wpv7G81V28WYbnZUG5YEI9rEk0
xej6JozKL1pkGsfbPhnermIniVn81NCjhnBcSSonPG3Q4DGT+lbmY7aOx2CAO4Eu
D1LhFQrQnls=
=2t79
-----END PGP SIGNATURE-----