X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 74EBB9FB274 for ; Fri, 28 Jul 2006 14:43:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 67208-08-2 for ; Fri, 28 Jul 2006 14:43:24 -0300 (ADT) X-Greylist: delayed 01:23:07.048685 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 030709FB286 for ; Fri, 28 Jul 2006 14:43:10 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from pjetlic.mobart.hr (pjetlic.mobart.hr [80.80.51.10]) by svr4.postgresql.org (Postfix) with ESMTP id 2A1635AFB83 for ; Fri, 28 Jul 2006 14:11:56 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by pjetlic.mobart.hr (Postfix) with ESMTP id AB2A817A30 for ; Fri, 28 Jul 2006 16:11:21 +0200 (CEST) Received: from pjetlic.mobart.hr ([127.0.0.1]) by localhost (pjetlic [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 20108-02-2 for ; Fri, 28 Jul 2006 16:11:21 +0200 (CEST) Received: from mike.mobart.hr (mike.mobart.hr [192.168.10.94]) (using SSLv3 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by pjetlic.mobart.hr (Postfix) with ESMTP id 8B4E117A0E for ; Fri, 28 Jul 2006 16:11:21 +0200 (CEST) Subject: Postgres replication solutions From: Mario Splivalo Reply-To: mario.splivalo@mobart.hr To: pgsql-admin@postgresql.org Content-Type: text/plain Organization: Mob-Art Date: Fri, 28 Jul 2006 16:11:20 +0200 Message-Id: <1154095881.18822.12.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.6.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by OpenSource AV+AS Mail Server X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.152 tagged_above=0 required=5 tests=AWL, SARE_SPEC_REPLICA, SPF_SOFTFAIL X-Spam-Level: * X-Archive-Number: 200607/260 X-Sequence-Number: 22506 Besides slony, is there any other postgres replication active project? I I need a solution where I could mirror a database to a 'spare' server, for statistical analysis (just SELECTs beeing done there), and 'lag' between actuall data and the slave server synchronisation can be even few hours. It would be awesome if it's not trigger-based. I looked on gborg.postgres.org, there are numerous replication projects, but for most of them last activity was in 2002. On pgfoundry I found nothing (I haven't spent much time there since the web-site is awfully slow). So, I'd like a recommendation. Mario -- Mario Splivalo Mob-Art mario.splivalo@mobart.hr "I can do it quick, I can do it cheap, I can do it well. Pick any two."