X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 57A9E11F65B7 for ; Fri, 14 Apr 2006 15:51:22 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -0.751 X-Spam-Level: X-Spam-Status: No, score=-0.751 required=5 tests=[ALL_TRUSTED=-1.44, AWL=-0.124, INFO_TLD=0.813] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id poUwTUHud1k8 for ; Fri, 14 Apr 2006 15:51:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 5A49D11F65E4 for ; Fri, 14 Apr 2006 15:51:19 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k3EIpGI5006439 for ; Fri, 14 Apr 2006 15:51:16 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k3EIc6YV004367 for pgsql-admin@postgresql.org; Fri, 14 Apr 2006 15:38:06 -0300 (ADT) (envelope-from news) From: Christopher Browne X-Newsgroups: pgsql.admin Subject: Re: Slony1 or DRBD for replication ? Date: Fri, 14 Apr 2006 14:14:56 -0400 Organization: cbbrowne Computing Inc Lines: 15 Message-ID: <87sloghvmn.fsf@wolfe.cbbrowne.com> References: <443F9BF3.4060101@laposte.net> <1145028323.5597.1.camel@localhost.localdomain> <443FDF05.4060600@laposte.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:52XPCYM9rNKXFOXA728NsEWLMh0= To: pgsql-admin@postgresql.org X-Archive-Number: 200604/132 X-Sequence-Number: 21301 In the last exciting episode, pierre.lebrech@laposte.net (Pierre LEBRECH) wrote: > Thanks for any suggestions and explanations. A third possibility would be PITR, new in version 8, if the point is to have recovery from big failure. You'd periodically copy the whole DB, and continually copy WAL files across the wire... See the PG docs; there's a whole chapter on it... -- output = ("cbbrowne" "@" "gmail.com") http://linuxdatabases.info/info/spreadsheets.html "It can be shown that for any nutty theory, beyond-the-fringe political view or strange religion there exists a proponent on the Net. The proof is left as an exercise for your kill-file." -- Bertil Jonell