Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 1C3BC6326D3 for ; Mon, 22 Feb 2010 10:40:54 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 47782-02 for ; Mon, 22 Feb 2010 14:40:34 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from hermes.vectorsf.com (firewall.vectorsf.com [62.82.80.62]) by mail.postgresql.org (Postfix) with ESMTP id 9138B63249C for ; Mon, 22 Feb 2010 10:40:41 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by hermes.vectorsf.com (Postfix) with ESMTP id 4E23A11C0286 for ; Mon, 22 Feb 2010 15:40:36 +0100 (CET) X-Virus-Scanned: amavisd-new at hermes.vectorsf.com Received: from hermes.vectorsf.com ([127.0.0.1]) by localhost (hermes.vectorsf.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id luZzBhTRhrPY for ; Mon, 22 Feb 2010 15:40:32 +0100 (CET) Received: from hermes.vectorsf.com (hermes.vectorsf.com [10.70.4.30]) by hermes.vectorsf.com (Postfix) with ESMTP id 15CA011C0285 for ; Mon, 22 Feb 2010 15:40:32 +0100 (CET) From: =?utf-8?Q?I=C3=B1igo_Martinez_Lasala?= To: References: <20100219054912.h2y7ff6n8up0kwgw@mail.artificialmachines.com> In-Reply-To: <20100219054912.h2y7ff6n8up0kwgw@mail.artificialmachines.com> Subject: Re: Using Postgresql Replication Date: Mon, 22 Feb 2010 15:40:32 +0100 (CET) Message-ID: <01bb01cab3cd$05b5ab60$11210220$@com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01BC_01CAB3D5.677A1360" X-Mailer: Microsoft Office Outlook 12.0 X-Mailer: Zimbra 5.0.20_GA_3127.RHEL4_64 (ZimbraConnectorForOutlook/5.0.3191.20) Content-Language: es Thread-Index: AcqxVpipDa4gZeFeTMiaRjpNcSrKVACdYDhA X-Originating-IP: [10.70.7.99] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.294 tagged_above=-10 required=5 tests=AWL=-1.871, BAYES_40=-0.185, FS_REPLICA=1.041, HTML_MESSAGE=0.001, SARE_SPEC_REPLICA=0.72 X-Spam-Level: X-Archive-Number: 201002/168 X-Sequence-Number: 33771 This is a multi-part message in MIME format. ------=_NextPart_000_01BC_01CAB3D5.677A1360 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 8bit PGcluster doesn’t work. One year ago we where trying to deploy a cluster using pgcluster and we were unable to get it work without problems. We finally selected slony. It works quite well and it’s quite easy to deploy by following tutorials. We worked with slony-I. However, slony only replicate data. You have to replicate manually triggers, functions, indexes, etc if you use them. We also tested pg pool and this one works very good. However you have to deal with some minor issues if you use special functions that make use of timestamps or random, for example. If you don’t use this kind of functions, you could test pg_pool. Pg_pool is easier to deploy than slony and also provides load balancing for reading. De: Manasi Save [mailto:manasi.save@artificialmachines.com] Enviado el: viernes, 19 de febrero de 2010 11:49 Para: pgsql-admin@postgresql.org Asunto: [ADMIN] Using Postgresql Replication Hi All, I am very new to Postgres in that I have to setup replication. For Which I am very confused between Postgres's replication types. I want a sychronized but a master-slave replication. I have read about Slony-I replication method. But I am confused if I have to manually setup slony-I replication for all databases. As the interface which I have seen for slony-I setup, it has given replication tab under every database. If I have to manually define replication master and slave node for any database I am creating then it is not a feasible option for me to use Slony-I. SLONY-I = Is it possible that all the databases getting created on Master Node will be replicated to specified Slave node. So, I thought of PGCluster. But it comes with multi-master replication. PGCluster = Is it possible that I can configure Master-Slave replication in PGCluster. Please let me know if I am unclear in any point. Any input will be a great help. Thanks in advance. -- Regards, Manasi Save ------=_NextPart_000_01BC_01CAB3D5.677A1360 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable

PGcluster doesn=E2=80=99t work. One year ago we where = trying to deploy a cluster using pgcluster and we were unable to get it work without = problems.

 

We finally selected slony. It works quite well and = it=E2=80=99s quite easy to deploy by following tutorials. We worked with slony-I. However, = slony only replicate data. You have to replicate manually triggers, functions, indexes, etc if you use them.

 

We also tested pg pool and this one works very good. = However you have to deal with some minor issues if you use special functions that = make use of timestamps or random, for example. If you don=E2=80=99t use this kind of = functions, you could test pg_pool.

Pg_pool is easier to deploy than slony and also provides = load balancing for reading.

 

 

De: Manasi = Save [mailto:manasi.save@artificialmachines.com]
Enviado el: viernes, 19 de febrero de 2010 11:49
Para: pgsql-admin@postgresql.org
Asunto: [ADMIN] Using Postgresql = Replication

 

Hi All,

 

I am very new to Postgres in that I have to setup replication. For = Which I am very confused between Postgres's replication types.

I want a sychronized but a master-slave replication.

I have read about Slony-I replication method. But I am confused if I = have to manually setup slony-I replication for all databases. As the interface = which I have seen for slony-I setup, it has given replication tab under every = database.

If I have to manually define replication master and slave node for = any database I am creating then it is not a feasible  option for me to = use Slony-I.

SLONY-I =3D Is it possible that all the databases getting created on = Master Node will be replicated to specified Slave node.

 

So, I thought of PGCluster. But it comes with multi-master = replication.

PGCluster =3D Is it possible that I can configure Master-Slave = replication in PGCluster.

 

Please let me know if I am unclear in any point. Any input will be a = great help.

 

Thanks in advance.


--
Regards,
Manasi Save

------=_NextPart_000_01BC_01CAB3D5.677A1360--