Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4556B9FB4F3 for ; Mon, 22 Oct 2007 06:06:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 21097-06 for ; Mon, 22 Oct 2007 06:05:57 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.179]) by postgresql.org (Postfix) with ESMTP id 6A1459FB3FA for ; Mon, 22 Oct 2007 06:05:57 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id m38so1579738waf for ; Mon, 22 Oct 2007 02:05:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; bh=4bPxcb4J8XRe39Hmd0FPxY9skG4SEJaOKgiIZkxrV3A=; b=rD9bSRbQfW7hMnv4X9X9Wd7zUo+mxHPc+IYUY/k8kRLBR6KnqEJIBLNAiXiab2+ejuvhXj5DTg8W3ngpjQpayjenX+511K4ocawM92jZxHFzT9vqpeLoag3Ccgz7DCOJzwbWcYqoy5OaBZNaGarYAp3zADo8y3ZzvysfAxaIRzs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=g0brj/vCKtQ2gqjH8O4j9HDGUZjmbzU1/8qBg3/tvqIxME8cB1751Ve60GE0+gX46BEddkzMi0IsQmMccXM79446vz6pycoXeV+jqYzAFpMZibbwDX6esrR7yeLfipJS+ac3Ytb35ceme13nKGdLKphLXlfnZzUpWdZWKFY8ZSg= Received: by 10.114.123.1 with SMTP id v1mr4998312wac.1193043955210; Mon, 22 Oct 2007 02:05:55 -0700 (PDT) Received: by 10.114.136.2 with HTTP; Mon, 22 Oct 2007 02:05:55 -0700 (PDT) Message-ID: Date: Mon, 22 Oct 2007 11:05:55 +0200 From: "Ewald Geschwinde" To: pgsql-admin@postgresql.org Subject: Re: Cluster/Replication In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_13807_16086725.1193043955197" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/207 X-Sequence-Number: 27121 ------=_Part_13807_16086725.1193043955197 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 10/22/07, cho wrote: > > Le Fri, 19 Oct 2007 12:43:40 -0400, Sean Brown a =E9crit: > > > We are setting up a new database system that is going to act as our > > central database. We are planning to have a Master/Slave setup, > > originally with one slave but there is a strong possibility of adding a > > second slave at our second site. We could run Mulit-Master, it just > > wasn't the original plan. (The original plan was MySQL log shipping). W= e > > do not want the possibility of loosing data in the event of loosing the > > master node so synchronous replication is preferable. We are using > > BLOBS, so the replication has to be able to handle that. The slave we > > want to have useable but it would be used for reporting only under > > normal usage. > > > If you want to use synchronous replication look at the link http://www.postgresql.at/english/downloads_e.html this is an enhanced and tested version of pgcluster - it's open source you can use it it is also working on windows --=20 Ewald Geschwinde ------=_Part_13807_16086725.1193043955197 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

On 10/22/07, cho <tobutaz@gmail.com= > wrote:
Le Fri, 19 Oct 2007 12:43:40 -0400, Sean Brown a =E9crit:

> We ar= e setting up a new database system that is going to act as our
> cent= ral database. We are planning to have a Master/Slave setup,
> origina= lly with one slave but there is a strong possibility of adding a
> second slave at our second site. We could run Mulit-Master, it jus= t
> wasn't the original plan. (The original plan was MySQL log sh= ipping). We
> do not want the possibility of loosing data in the even= t of loosing the
> master node so synchronous replication is preferable. We are using=
> BLOBS, so the replication has to be able to handle that. The slave= we
> want to have useable but it would be used for reporting only un= der
> normal usage.



If you want to use= synchronous replication look at the link

http://www.postgresql.at/english/downl= oads_e.html

this is an enhanced and tested version of pgcluster - it's = open source you can use it
it is also working on windows

-- Ewald Geschwinde ------=_Part_13807_16086725.1193043955197--