Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 142742E006D for ; Mon, 16 Jun 2008 05:03:52 -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 46183-06 for ; Mon, 16 Jun 2008 05:03:27 -0300 (ADT) X-Greylist: delayed 00:15:45.722824 by SQLgrey-1.7.6 Received: from viefep26-int.chello.at (viefep26-int.chello.at [62.179.121.46]) by developer.postgresql.org (Postfix) with ESMTP id E32222E0055 for ; Mon, 16 Jun 2008 05:02:39 -0300 (ADT) Received: from [192.168.1.11] (really [80.108.204.36]) by viefep20-int.chello.at (InterMail vM.7.08.02.02 201-2186-121-104-20070414) with ESMTP id <20080616074653.BZYI10286.viefep20-int.chello.at@[192.168.1.11]> for ; Mon, 16 Jun 2008 09:46:53 +0200 Subject: Replication, HA ...? From: Andreas Kraftl To: pgsql-admin@postgresql.org Content-Type: text/plain; charset=UTF-8 Date: Mon, 16 Jun 2008 09:46:57 +0200 Message-Id: <1213602417.7913.6.camel@zeus.mythos> Mime-Version: 1.0 X-Mailer: Evolution 2.12.1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.899 tagged_above=0 required=5 tests=FS_REPLICA=1.179, SARE_SPEC_REPLICA=0.72 X-Spam-Level: * X-Archive-Number: 200806/122 X-Sequence-Number: 29460 Hello, I have a webserver with postgresql. I would have a backup from this database. It should also be possible to query this backup solution. So I think slony would be a good choice. Am I right? Thanks for answers Andreas -- Kraftl EDV - Dienstleistungen Schulungen, Linux, Linuxlösungen, Webprogrammierung Autofabrikstraße 16/6, 1230 Wien, Österreich http://www.kraftl.at/