Re: pg_service.conf - Mailing list pgsql-hackers

From Douglas McNaught
Subject Re: pg_service.conf
Date
Msg-id 87d5hjtmyu.fsf@suzuka.mcnaught.org
Whole thread Raw
In response to Re: pg_service.conf  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: pg_service.conf
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.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.

Of course, you'd need an internal DNS server that you had full control
over...

-Doug


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: pg_service.conf
Next
From: Martijn van Oosterhout
Date:
Subject: Re: pg_service.conf