Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 365A22E0051 for ; Mon, 16 Jun 2008 09:44:35 -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 31034-04-6 for ; Mon, 16 Jun 2008 09:44:27 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by developer.postgresql.org (Postfix) with ESMTP id E56AF2E0114 for ; Mon, 16 Jun 2008 09:17:18 -0300 (ADT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1K8Ddx-0001Zs-K8 for pgsql-admin@postgresql.org; Mon, 16 Jun 2008 12:17:05 +0000 Received: from mekk.waw.pl ([82.195.149.110]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 16 Jun 2008 12:17:05 +0000 Received: from Marcin.Kasperski by mekk.waw.pl with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 16 Jun 2008 12:17:05 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: Marcin Kasperski Subject: Re: Replication, HA ...? Date: Mon, 16 Jun 2008 14:21:51 +0200 Lines: 9 Message-ID: <87ve091sf4.fsf@softax.com.pl> References: <1213602417.7913.6.camel@zeus.mythos> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: mekk.waw.pl User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) Cancel-Lock: sha1:scr1t/Im0BtgJZvpRMud8G+5WE4= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.783 tagged_above=0 required=5 tests=AWL=-1.116, FS_REPLICA=1.179, SARE_SPEC_REPLICA=0.72 X-Spam-Level: X-Archive-Number: 200806/127 X-Sequence-Number: 29465 > 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? Slony will replicate the data from selected tables for you, and the replicated database will be available for queries. So it will work for you unless you face performance limits, or have some problem with asynchronous updates, or find Slony setup to be too difficult.