X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6B1F25381D for ; Wed, 30 Mar 2005 15:51:46 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 15734-10 for ; Wed, 30 Mar 2005 14:51:38 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.202]) by svr1.postgresql.org (Postfix) with ESMTP id BD6585382B for ; Wed, 30 Mar 2005 15:51:36 +0100 (BST) Received: by wproxy.gmail.com with SMTP id 68so179116wra for ; Wed, 30 Mar 2005 06:51:41 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=rDp5l6cPLTL+ECXHc7Ehuoxka4YJZ9b8CPA31oaChQk+YXIBBalnGk0bIOxm3YU4/toNR9bsUVMXSaJQB9yTaEcfryy125dyTVFRcsW8RfkhedB/6aNbXvUJy1kQX7t0onyAN20l+nqFZu4hMeUNw4grwP7TKaFVASwfboxxBEM= Received: by 10.54.8.48 with SMTP id 48mr6816wrh; Wed, 30 Mar 2005 06:51:38 -0800 (PST) Received: by 10.54.29.7 with HTTP; Wed, 30 Mar 2005 06:51:37 -0800 (PST) Message-ID: <9250651c0503300651788c62c6@mail.gmail.com> Date: Wed, 30 Mar 2005 11:51:37 -0300 From: Marco Carvalho Reply-To: Marco Carvalho To: pgsql-admin@postgresql.org Subject: multiple servers updating from/to one Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.398 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200503/477 X-Sequence-Number: 16975 Hi, all I need to do this scenario: Web Application Web Application Web Application | | | pgsql server 1 pgsql server 2 pgsql server 3 | | | | | | | adsl | adsl | adsl | | | | | | ------------------------------------------------------- | pgsql server ("master") I need various servers in different locations running exactly some things, one Web Application and one pgsql server, all synchronizing with "master" server through unstable adsl connections. So, If I do one insert in server 1, this data goes to "master" and is available to other servers, and vice-versa, and if adsl connection broken, Web Application still working with local server and when connection is restored both databases are synchronized. Is this possible? If it's true, what tools I need? Thanks in advance to any help, and sorry for my bad English (if someone can't understand I say, I try to be more clear). Cheers, Marco Carvalho