TNS Services like Oracle?

From: Mario Weilguni <mweilguni(at)sime(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: TNS Services like Oracle?
Date: 2000-08-26 09:08:10
Message-ID: 00082611081004.00410@loki
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

-----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-----

Browse pgsql-hackers by date

  From Date Subject
Next Message Jules Bean 2000-08-26 10:48:58 Re: Performance on inserts
Previous Message Thomas Lockhart 2000-08-26 07:27:28 Re: Performance on inserts