From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Douglas McNaught <doug(at)mcnaught(dot)org> |
Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, Mark Woodward <pgsql(at)mohawksoft(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: pg_service.conf |
Date: | 2006-02-19 15:10:29 |
Message-ID: | 20060219151029.GD1323@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
On Sun, Feb 19, 2006 at 09:58:01AM -0500, Douglas McNaught wrote:
> Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
>
> > A server-side (i.e. centrally managed) name server seems like an
> > improvement over the client-side solutions described, IMHO, but I'd
> > leave it to others to describe how that might work. (e.g. DNS is a
> > better solution than multiple distributed /etc/hosts files).
>
> Funnily enough, you could *use* DNS for this--you could define a
> custom RR type containing hostname, port, database etc and have
> entries in DNS for each "service" (e.g. 'production-db.mycorp.com').
> I think HESIOD used this mechanism.
Well, there exist such things as SRV records already for describing how
to find services. In theory you could create an entry like:
_postgres._tcp.example.com SRV 10 5 5432 db1.example.com
So that if you typed "psql example.com" it would lookup the server and
port number. You may be able to put a dbname after that, not sure. And
you can always put whatever you like into a TXT record.
In any case, someone still needs to write the code for it.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Woodward | 2006-02-19 15:41:04 | Re: pg_service.conf |
Previous Message | Mark Woodward | 2006-02-19 15:00:01 | pg_service.conf |
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Woodward | 2006-02-19 15:41:04 | Re: pg_service.conf |
Previous Message | Mark Woodward | 2006-02-19 15:00:01 | pg_service.conf |