Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id CA7452E037C for ; Tue, 4 Mar 2008 20:01:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 72774-02 for ; Tue, 4 Mar 2008 20:01:32 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from skynet.simkin.ca (skynet.simkin.ca [72.51.27.117]) by postgresql.org (Postfix) with ESMTP id D59732E0145 for ; Tue, 4 Mar 2008 20:01:30 -0400 (AST) Received: from charon.medialogik.com (charon.medialogik.com [72.51.27.114]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by skynet.simkin.ca (Postfix) with ESMTP id 700DE46F1 for ; Tue, 4 Mar 2008 16:01:29 -0800 (PST) From: Alan Hodgson Organization: Simkin Network Consulting To: pgsql-general@postgresql.org Subject: Re: using warm standby with drbd??? Date: Tue, 4 Mar 2008 16:02:15 -0800 User-Agent: KMail/1.9.6 (enterprise 0.20070907.709405) References: <9abe84da0803041407u3abd92a6oc4ab099f5c3b2d1b@mail.gmail.com> In-Reply-To: <9abe84da0803041407u3abd92a6oc4ab099f5c3b2d1b@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200803041602.15961@hal.medialogik.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/113 X-Sequence-Number: 129435 On Tuesday 04 March 2008, "libra dba" wrote: > How else can i replicate the wal_files? ( i don't want to user common > file system ,,, NFS,,, etc.)? scp > > Another thing which i want to ask is that if we are generating archives > every 1 minute. then what happens to the data which was written to the > server A after 35 seconds after the last wal file generation.(server A > crashes). > It's gone. If that isn't acceptable then I would suggest putting the active pg_xlog directory on drbd. That may have speed implications. -- Alan