Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 904489FBA4C for ; Thu, 28 Jun 2007 07:20:30 -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 33294-07 for ; Thu, 28 Jun 2007 07:20:20 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.170]) by postgresql.org (Postfix) with ESMTP id 0F7449FBB06 for ; Thu, 28 Jun 2007 07:20:19 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id a2so70484ugf for ; Thu, 28 Jun 2007 03:20:18 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=VDeQUZWjWm3F16CBLBvfm2ToITYF6MfUiZTJ7CsPl44+82VMUQ/jbHGIzU6JiRIeb2WP8Xp4u81+UYoAHJpvimO5KFVz7EhF9aSTp5V1mrbyP4N7McjO11yZT6IU6XQPqDvP4Of78dm+L6JqQKWJ6JOjpIUwyJDgXjADj+CdObY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=ZfvnjWRn9aEek+ghI4tNuIBMgANA7YJ+5botlHeZmUhGPIBupvtiTQd7vKF+hwmaeZewjL+pDm1dWngnUjG5Bs149+7Gk0AKVMzuYVgoYCQQUlvaflR1NF10EnoM54x6eIvlpwVbZMTxm86XvI4K9pkGFpVW2LX4R/7hNGXQHSY= Received: by 10.82.175.17 with SMTP id x17mr3454336bue.1183026018238; Thu, 28 Jun 2007 03:20:18 -0700 (PDT) Received: by 10.82.155.10 with HTTP; Thu, 28 Jun 2007 03:20:18 -0700 (PDT) Message-ID: <9e4684ce0706280320w7c4d69afvf75258b4d83ffd7d@mail.gmail.com> Date: Thu, 28 Jun 2007 12:20:18 +0200 From: "hubert depesz lubaczewski" To: "POLONKAI Gergely" Subject: Re: Distributed database with PostgreSQL Cc: pgsql-admin@postgresql.org In-Reply-To: <4683786A.5070608@w00d5t0ck.info> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_56103_7842124.1183026018216" References: <468372D8.5050104@w00d5t0ck.info> <9e4684ce0706280142r1100326ey473a6b48c0714e09@mail.gmail.com> <4683786A.5070608@w00d5t0ck.info> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/287 X-Sequence-Number: 25955 ------=_Part_56103_7842124.1183026018216 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 6/28/07, POLONKAI Gergely wrote: > > hubert depesz lubaczewski =EDrta: > Actually, it is not replication we need, as all the nodes are equal, so > there is no master server at all. I'm googling around now with these > keywords tho, but I think this is not we need... > if the nodes are equal it's not the case that there is no master, but rathe= r - there are no slave nodes. so it would look like a situation for multi-master replication. unfortunately there is no such system yes for postgresql.there are some tha= t do things alike to multi-master replication, but none of them is full multi-master replication system. you can try your luck with pgpool/pgpool2 or sequoia. depesz --=20 http://www.depesz.com/ - nowy, lepszy depesz ------=_Part_56103_7842124.1183026018216 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 6/28/07, POLONKAI Gergely <polesz@w00d5t0ck.info> wrote:
=
hubert depesz lubaczewski =EDrta:
Actually, it is not replication we nee= d, as all the nodes are equal, so
there is no master server at all. I= 9;m googling around now with these
keywords tho, but I think this is not= we need...

if the nodes are equal it's not the case tha= t there is no master, but rather - there are no slave nodes.
so it would= look like a situation for multi-master replication.
unfortunately ther= e is no such system yes for=20 postgresql.there are some that do things alike to multi-master replication,= but none of them is full multi-master replication system.
you can try y= our luck with pgpool/pgpool2 or sequoia.

depesz

--
http://www.depesz.com/ - = nowy, lepszy depesz ------=_Part_56103_7842124.1183026018216--