From: Dave Pooser <dave-pg@pooserville.com>
To: PostgreSQL List <pgsql-admin@postgresql.org>
Subject: Multiple LDAP servers -- no failover?
Date: Wed, 10 Oct 2012 12:41:10 -0500
Message-ID: <CC9B1D66.51792%dave-pg@pooserville.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: dave-pg@pooserville.com
Subject: Re: Multiple LDAP servers -- no failover?
In-Reply-To: <CC9B1D66.51792%dave-pg@pooserville.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox