X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B91E49DCA9F for ; Sun, 4 Dec 2005 21:22:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20642-05 for ; Sun, 4 Dec 2005 21:22:24 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.192]) by postgresql.org (Postfix) with ESMTP id 7DB3F9DCCED for ; Sun, 4 Dec 2005 21:22:26 -0400 (AST) Received: by zproxy.gmail.com with SMTP id o1so595881nzf for ; Sun, 04 Dec 2005 17:22:28 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=BEMev7Mm9oen6sgZn5PQScT6BujYDxMdSWgvaMky8/MljDn3I6pcv9I8526IpZsMlPhmbQoKzFgz9bu0kkG0x3gWjzviKHnqvcbQUkleMQHnE2SpQtxJ/Q4E01n2mKIPvAvSy5IdMLXE7clL23xIKSATr+RHhMwwu2vE+r/Pc7I= Received: by 10.65.213.10 with SMTP id p10mr2424952qbq; Sun, 04 Dec 2005 17:22:27 -0800 (PST) Received: by 10.64.153.16 with HTTP; Sun, 4 Dec 2005 17:22:27 -0800 (PST) Message-ID: <731083980512041722n5e8feff8v@mail.gmail.com> Date: Sun, 4 Dec 2005 23:22:27 -0200 From: Rodrigo Hjort To: Brendan Duddridge Subject: Re: Postgresql Replication High Availability Cc: pgsql-admin@postgresql.org In-Reply-To: <8D02A94B-8E41-41BB-B9DB-8C5D29DC143D@clickspace.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <731083980512021932v7b3236cdg@mail.gmail.com> <8C2FC712-48C3-41BA-8596-3052B2B75A25@clickspace.com> <731083980512041041o27e363a0s@mail.gmail.com> <8D02A94B-8E41-41BB-B9DB-8C5D29DC143D@clickspace.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.107 required=5 tests=[AWL=0.107] X-Spam-Score: 0.107 X-Spam-Level: X-Archive-Number: 200512/29 X-Sequence-Number: 19749 The plan is the 3rd option, to achieve Fail Over capabilities. There will be 2 or more servers running only Sequoia Controller, pointing to a group of PostgreSQL backends each one. The application server will use Sequoia JDBC Driver (not PostgreSQL JDBC anymore) where those controllers will be specified. No more modifications are needed to do it! Well, the exception is a string on the setting XML used by Hibernate... 2005/12/4, Brendan Duddridge : > Hi Rodrigo, > > So where did you install sequoia? On your application servers? On > your database servers? Or on dedicated servers running only sequoia? > > Thanks, > > ____________________________________________________________________ > Brendan Duddridge | CTO | 403-277-5591 x24 | brendan@clickspace.com > > ClickSpace Interactive Inc. > Suite L100, 239 - 10th Ave. SE > Calgary, AB T2G 0V9 > > http://www.clickspace.com > Regards, Rodrigo Hjort GTI - Projeto PostgreSQL CELEPAR - Cia de Inform=E1tica do Paran=E1 http://www.pr.gov.br