From: | Steve Atkins <steve(at)blighty(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: pg_service.conf |
Date: | 2006-02-19 22:14:47 |
Message-ID: | F0D14C58-BBA4-4C9C-958A-FAD4D40BDC4F@blighty.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
On Feb 19, 2006, at 10:59 AM, Mark Woodward wrote:
>> "Mark Woodward" <pgsql(at)mohawksoft(dot)com> writes:
>>
>>> DNS isn't always a better solution than /etc/hosts, both have
>>> their pros
>>> and cons. The /etc/hosts file is very useful for "instantaneous,"
>>> reliable, and redundent name lookups. DNS services, espcially in
>>> a large
>>> service environment can get bogged down. 20,000 hosts doing a lot of
>>> lookups can require a dedicated single point of failure. OK, so
>>> you add
>>> two DNS machines and load balance across them with a fault tollerant
>>> load
>>> balancer, how many thousands of dollars? For how much information? A
>>> simple "clustercpy -f targets pg_service.conf /etc" would save
>>> thousands
>>> of dollars, increase efficiency, increase reliability, decrease
>>> electrical
>>> costs, etc.
>>
>> Um, is there something wrong with having multiple DNS servers in
>> resolv.conf? Other than having to time out on #1 before you try #2?
>> I'm genuinely curious.
>
> What is the "timeout" of that DNS lookup, before it goes to the
> second DNS
> server?
Depends on the resolver you use. Often the "timeout" is zero. Other
times
it's adaptive, depending on history of response time from the servers.
Except in the case of horrible misconfiguration, it's rarely a problem.
Cheers,
Steve
From | Date | Subject | |
---|---|---|---|
Next Message | Albert Chin | 2006-02-19 22:29:32 | Re: Fix to CVE-2006-0553 for 8.1.1 |
Previous Message | Tom Lane | 2006-02-19 22:14:32 | Re: Fix to CVE-2006-0553 for 8.1.1 |
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2006-02-19 23:59:44 | Re: patch fixing the old RETURN NEXT bug |
Previous Message | Douglas McNaught | 2006-02-19 20:50:58 | Re: pg_service.conf |