Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 3BFF76324A7
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 13 Jul 2010 06:42:05 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 89093-06 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 13 Jul 2010 09:41:57 +0000 (UTC)
X-Greylist: delayed 00:08:18.501284 by SQLgrey-1.7.6
Received: from mxs.selfmail.ru (unknown [77.221.143.26])
	by mail.postgresql.org (Postfix) with ESMTP id 153AC632372
	for <pgsql-admin@postgresql.org>; Tue, 13 Jul 2010 06:41:57 -0300 (ADT)
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=selfip.ru;
	s=dk;
	h=Content-Transfer-Encoding:Mime-Version:Message-ID:Date:Content-Type:To:Reply-To:From:Subject;
	bh=M9/0GO/yanl7Jp9NNaQyb6/HtC8WPM2Hb3Nei7Avdq4=;
	b=E1RA6zgOsJWnxG8eergs27YeC7rZcbjfDmRCJRPjqBf7pqXkOOcHPSA5qvvxhRRFkyz7DaJ/NimsuPLUlXpCeMcPURWrS9tEahpzFAuSgDdE0Qdd0b6KyK+4/SawpPN2;
X-ACL-SPF: 
Received: from [UNAVAILABLE] ([85.142.60.148]:55823 helo=[192.168.1.101])
	by mxs.selfmail.ru with esmtpa (Exim 4.72)
	(envelope-from <v.tolstov@selfip.ru>) id 1OYbrs-0006gu-17
	for pgsql-admin@postgresql.org; Tue, 13 Jul 2010 13:33:36 +0400
Subject: postgresql failover
From: Vasiliy G Tolstov <v.tolstov@selfip.ru>
Reply-To: v.tolstov@selfip.ru
To: PostgreSQL Admin <pgsql-admin@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Organization: Selfip.Ru
Date: Tue, 13 Jul 2010 13:33:25 +0400
Message-ID: <1279013605.5517.48.camel@work.selfip.ru>
Mime-Version: 1.0
X-Mailer: Evolution 2.28.3 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.792 tagged_above=-10 required=5
	tests=BAYES_40=-0.001, RDNS_NONE=0.793
X-Spam-Level: 
X-Archive-Number: 201007/54
X-Sequence-Number: 35073

Hello.

I need failover postgresql installation. Two servers work's together. If
one server fail - another server doing queries. 
In MySQL i'm use two server (mysql-ndb and two mysql api server (getting
queries) with mysql-proxy. If one server fail mysql-proxy route all
queries to another.

How can i do this in postgresql?

-- 
Vasiliy G Tolstov <v.tolstov@selfip.ru>
Selfip.Ru