HA for PostgreSQL (Auth-Server)

From: Michelle Konzack <linux4michelle(at)tamay-dogan(dot)net>
To: pgSQL - General <pgsql-general(at)postgresql(dot)org>
Subject: HA for PostgreSQL (Auth-Server)
Date: 2010-06-24 09:27:24
Message-ID: 20100624092724.GF21273@tamay-dogan.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello *,

in my enterprise I have an Intranet-Server with NFSv4, Courier, Apache
and PostgreSQL and if this Server goes down, nothing will work anymore.

OK, I replicate the WHOLE server all 6 hours, but my PostgreSQL give me
a bunch of headache, becasue I use "pam-pgsql" for authentication.

What is the best practize to build the PgSQL in HA using a second/third
external server to keep authentication alive?

I am onging to put, the PostgregSQL on three or more Marvel MV78200 with
attached 4-port SAS controller (using three 74GByte SAS Drives in Raid-1
plus Hotfix) since the Intranet Database itself is only arround 13 GByte

Thanks, Greetings and nice Day/Evening
Michelle Konzack

--
##################### Debian GNU/Linux Consultant ######################
Development of Intranet and Embedded Systems with Debian GNU/Linux

itsystems(at)tdnet France EURL itsystems(at)tdnet UG (limited liability)
Owner Michelle Konzack Owner Michelle Konzack

Apt. 917 (homeoffice)
50, rue de Soultz Kinzigstraße 17
67100 Strasbourg/France 77694 Kehl/Germany
Tel: +33-6-61925193 mobil Tel: +49-177-9351947 mobil
Tel: +33-9-52705884 fix

<http://www.itsystems.tamay-dogan.net/> <http://www.flexray4linux.org/>
<http://www.debian.tamay-dogan.net/> <http://www.can4linux.org/>

Jabber linux4michelle(at)jabber(dot)ccc(dot)de
ICQ #328449886

Linux-User #280138 with the Linux Counter, http://counter.li.org/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2010-06-24 09:30:00 Re: Bad query performance with more conditions?
Previous Message kaifeng.zhu 2010-06-24 09:18:06 Re: Bad query performance with more conditions?