X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 06A9D3A62B3 for ; Fri, 28 Jan 2005 15:36:37 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63133-08 for ; Fri, 28 Jan 2005 15:36:19 +0000 (GMT) Received: from smtp103.rog.mail.re2.yahoo.com (smtp103.rog.mail.re2.yahoo.com [206.190.36.81]) by svr1.postgresql.org (Postfix) with SMTP id 0BA633A632F for ; Fri, 28 Jan 2005 15:36:21 +0000 (GMT) Received: from unknown (HELO phlogiston.dydns.org) (a.sullivan@rogers.com@216.75.167.195 with login) by smtp103.rog.mail.re2.yahoo.com with SMTP; 28 Jan 2005 15:36:21 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 9EE583F9E; Fri, 28 Jan 2005 10:36:20 -0500 (EST) Date: Fri, 28 Jan 2005 10:36:20 -0500 From: Andrew Sullivan To: Postgresql Performance Subject: Re: PostgreSQL clustering VS MySQL clustering Message-ID: <20050128153620.GE9076@phlogiston.dyndns.org> Mail-Followup-To: Postgresql Performance References: <200501201503.31241.herve@elma.fr> <41EFBF05.6000509@familyhealth.com.au> <200501201536.08656.herve@elma.fr> <1106236978.35299.496.camel@home> <1106522910.5790.1.camel@fuji.krosing.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1106522910.5790.1.camel@fuji.krosing.net> User-Agent: Mutt/1.5.6+20040907i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.032 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/574 X-Sequence-Number: 10264 On Mon, Jan 24, 2005 at 01:28:29AM +0200, Hannu Krosing wrote: > > IIRC it hates pg_dump mainly on master. If you are able to run pg_dump > from slave, it should be ok. For the sake of the archives, that's not really a good idea. There is some work afoot to solve it, but at the moment dumping from a slave gives you a useless database dump. A -- Andrew Sullivan | ajs@crankycanuck.ca The fact that technology doesn't work is no bar to success in the marketplace. --Philip Greenspun