Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id AA8739F9EF0 for ; Fri, 19 Oct 2007 14:06:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 62943-05 for ; Fri, 19 Oct 2007 14:06:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 36C469FA22D for ; Fri, 19 Oct 2007 14:06:20 -0300 (ADT) Received: from scratch (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l9JH6IRr029861; Fri, 19 Oct 2007 10:06:18 -0700 Date: Fri, 19 Oct 2007 10:06:26 -0700 From: "Joshua D. Drake" To: Sean Brown Cc: pgsql-admin@postgresql.org Subject: Re: Cluster/Replication Message-ID: <20071019100626.09fd9e13@scratch> In-Reply-To: References: Organization: Joshua D. Drake X-Mailer: Claws Mail 3.0.2 (GTK+ 2.12.0; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/AaQjG8PV=GvSwjAmjkm0Jt2"; protocol="application/pgp-signature"; micalg=PGP-SHA1 X-Virus-Scanned: ClamAV 0.91.1/4545/Wed Oct 17 14:05:57 2007 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Fri, 19 Oct 2007 10:06:19 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/194 X-Sequence-Number: 27108 --Sig_/AaQjG8PV=GvSwjAmjkm0Jt2 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable On Fri, 19 Oct 2007 12:43:40 -0400 Sean Brown wrote: > I believe this has come up before, and I am still researching how to =20 > do this and figured asking was probably a good idea as hopefully I =20 > can either get some direction or someone can point me at something I =20 > haven't seen yet. Why do you have a synchronous requirement? >=20 > We are setting up a new database system that is going to act as our =20 > central database. We are planning to have a Master/Slave setup, =20 > 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). We 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. >=20 > Slony is out because of the BLOB requirement and it's asynchronous. =20 > We are looking at pgCluster, but the replication server looks like a =20 > single point of failure itself. Also we're not really clear on how =20 > the replication server or load balancer operates for determining the =20 > load and size of the system it would have to run them on. >=20 > There are a few other things like how to handle postgresql version =20 > upgrades but thats probably best left to specific forums once a =20 > solution is chosen. >=20 > Is pgCluster the way to go or are there other projects we might want =20 > to look at? >=20 > Thank you in advance. >=20 >=20 > ---------------------------(end of > broadcast)--------------------------- TIP 1: if posting/reading > through Usenet, please send an appropriate subscribe-nomail command > to majordomo@postgresql.org so that your message can get through to > the mailing list cleanly >=20 --=20 =3D=3D=3D The PostgreSQL Company: Command Prompt, Inc. =3D=3D=3D Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ --Sig_/AaQjG8PV=GvSwjAmjkm0Jt2 Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHGOQSATb/zqfZUUQRAkl3AJ9P4Scfvk9YXjbTWNGdXROfe/Q7QwCfV0r4 W4P+zDTnXNgJfOXX9m+EkFY= =Gpk0 -----END PGP SIGNATURE----- --Sig_/AaQjG8PV=GvSwjAmjkm0Jt2--