Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 1A3BD9FC09E for ; Thu, 18 Oct 2007 12:20:05 -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 82701-01 for ; Thu, 18 Oct 2007 12:19:59 -0300 (ADT) X-Greylist: delayed 00:30:05.164813 by SQLgrey-1.7.5 Received: from biomag.usp.br (biomag.neuroimago.usp.br [143.107.137.222]) by postgresql.org (Postfix) with ESMTP id 67FC49FA285 for ; Thu, 18 Oct 2007 12:19:58 -0300 (ADT) Received: from biomag.usp.br (localhost.usp.br [127.0.0.1]) by biomag.usp.br (Postfix) with ESMTP id E9878E0422 for ; Thu, 18 Oct 2007 11:47:56 +0000 (UTC) From: "Walfred Tedeschi" To: pgsql-admin@postgresql.org Subject: Replication advice Many-to-one Slony Date: Thu, 18 Oct 2007 12:47:56 +0100 Message-Id: <20071018114038.M97749@biomag.usp.br> X-Mailer: OpenWebMail 2.52 20060502 X-OriginatingIP: 141.35.91.47 (fred) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.806 tagged_above=0 required=5 tests=BAYES_50=0.001, DATE_IN_PAST_03_06=0.044, FS_REPLICA=1.041, SARE_SPEC_REPLICA=0.72 X-Spam-Level: * X-Archive-Number: 200710/170 X-Sequence-Number: 27084 Hi all, We intend to establish a central back-up for our system. It can be though as many machines (masters) linked to one Slave. The communication may be one directional (master -> slave) and would appreciate to have it almost in realtime. The data flux on the system is not very high in terms of transactions and volume of data. And the primary keys are planned in a way that there is no overlap over the masters (every master has its own range of PK) without overlapping. We were thinking about slony1. Since we are not sure about the decision, we would appreciate very much if you could advise us what to use and where to start. Thank you very much, Fred -- Open WebMail Project (http://openwebmail.org)