Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 2FB072E0037 for ; Thu, 1 May 2008 10:04:36 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 08086-08 for ; Thu, 1 May 2008 10:04:27 -0300 (ADT) Received: from mx1.hub.org (mx1.hub.org [200.46.208.106]) by developer.postgresql.org (Postfix) with ESMTP id 98F7F2E002D for ; Thu, 1 May 2008 10:04:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from brmea-mail-1.sun.com (brmea-mail-1.Sun.COM [192.18.98.31]) by mx1.hub.org (Postfix) with ESMTP id 016A7B08460 for ; Thu, 1 May 2008 10:04:23 -0300 (ADT) Received: from fe-amer-09.sun.com ([192.18.109.79]) by brmea-mail-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id m41D1sMf025705 for ; Thu, 1 May 2008 13:01:54 GMT Received: from conversion-daemon.mail-amer.sun.com by mail-amer.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0K0600L01XEADZ00@mail-amer.sun.com> (original mail from J.K.Shah@Sun.COM) for pgsql-admin@postgresql.org; Thu, 01 May 2008 07:01:54 -0600 (MDT) Received: from [129.148.168.2] by mail-amer.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0K0600H8DXJ1N620@mail-amer.sun.com>; Thu, 01 May 2008 07:01:50 -0600 (MDT) Date: Thu, 01 May 2008 09:00:25 -0400 From: "Jignesh K. Shah" Subject: Re: help about replication In-reply-to: To: Igniris Valdivia Baez Cc: =?ISO-8859-1?Q?Thomas_Br=E4utigam?= , "Joshua D. Drake" , Robert.Lor@Sun.COM, pgsql-admin@postgresql.org Message-id: <4819BEE9.5020905@sun.com> Organization: Sun Microsystems MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 8BIT References: <46F5921DF52F6E40860287B30CADADC78172B9@EROS.nexus-ag.com> <48168B9A.8060704@sun.com> <46F5921DF52F6E40860287B30CADADC785F3EA@EROS.nexus-ag.com> <20080429165224.6d95756a@jd-laptop> <46F5921DF52F6E40860287B30CADADC785F3EE@EROS.nexus-ag.com> <20080429173304.3332f298@jd-laptop> <46F5921DF52F6E40860287B30CADADC785F3F4@EROS.nexus-ag.com> <439A43A5D3017748BFC0412BA7C160484FBB08D0@ucixs34.uci.cu> User-Agent: Thunderbird 2.0.0.9 (X11/20080119) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.221 tagged_above=0 required=5 tests=AWL=-1.678, FS_REPLICA=1.179, SARE_SPEC_REPLICA=0.72 X-Spam-Level: X-Archive-Number: 200805/5 X-Sequence-Number: 29089 Igniris Valdivia Baez wrote: > Hola > Soy estudiante de Ingeniería Informática. Le escribo porque consulté una publicación suya en la web sobre POSTGRESQL y más específicamente mi duda es sobre replica, tenemos un escenario de la siguiente manera, queremos montar una aplicación para el país completo, que es necesario que todos puedan consultar y modificar sobre los mismos datos y tenemos la duda si usar PgCluster nos seria factible? y si es así si seria síncrono o asíncrono. Otra cosa, que seria el replicador(hardware o software) y el balanceador de carga. > Gracias de antemano > Saludos Igniris > > Allright I used google translate to understand the email " Hello I am a student of computer engineering. I am writing you because I consulted a publication on the web and more specifically on POSTGRESQL is definitely on my replica, we have a scenario as follows, we want to mount an application for the whole country, it is necessary that everyone can see and change on them data and we doubt if we use PgCluster feasible? and if so whether serious synchronous or asynchronous. Another thing that would be the replicator (hardware or software) and the load balancer. Thanks in advance Greetings Igniris " Anyway I dont think I have any answers to this. -Jignesh