User-Agent: Microsoft-MacOutlook/14.2.4.120824
Date: Wed, 10 Oct 2012 12:41:10 -0500
Subject: Multiple LDAP servers -- no failover?
From: Dave Pooser <dave-pg@pooserville.com>
To: PostgreSQL List <pgsql-admin@postgresql.org>
Message-ID: <CC9B1D66.51792%dave-pg@pooserville.com>
Thread-Topic: Multiple LDAP servers -- no failover?
Mime-version: 1.0
Content-type: text/plain;
	charset="US-ASCII"
Content-transfer-encoding: 7bit

I have two LDAP servers listed in my pg_hba.conf:

local   all         all                               trust
host    all         all         127.0.0.1/32          trust
host    all     all     192.168.1.0/24         ldap
ldapserver="backup.example.com primary.example.com"
ldapsuffix="@example.com"
It authenticates fine to backup; if I change the pg_hba.conf to
primary.example.com it works fine as well. But with the above settings, if
I unplug the network cable to backup then instead of failing over to
primary instead it just hangs for 60s and then fails silently.

Should this setup work for failover, or is it only for situations where a
user might exist on primary.example.com but not on backup.example.com?

-- 
Dave Pooser
Cat-Herder-in-Chief, Pooserville.com
"...Life is not a journey to the grave with the intention of arriving
safely in one pretty and well-preserved piece, but to slide across the
finish line broadside, thoroughly used up, worn out, leaking oil, and
shouting GERONIMO!!!" -- Bill McKenna