Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C483F476F4A for ; Fri, 24 Jan 2003 11:37:25 -0500 (EST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id C65784770E2 for ; Fri, 24 Jan 2003 11:13:28 -0500 (EST) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 18c6ST-0001o8-00 for ; Fri, 24 Jan 2003 11:13:33 -0500 Date: Fri, 24 Jan 2003 11:13:33 -0500 From: Andrew Sullivan To: PgSQL Performance ML Subject: Re: Having trouble with backups (was: Re: Crash Recovery) Message-ID: <20030124111333.C32645@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , PgSQL Performance ML References: <2147483647.1043361178@[10.0.1.133]> <1043416377.29437.70.camel@haggis> <3E3158DA.7080807@mochima.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <3E3158DA.7080807@mochima.com>; from moreno@mochima.com on Fri, Jan 24, 2003 at 10:16:42AM -0500 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/285 X-Sequence-Number: 932 On Fri, Jan 24, 2003 at 10:16:42AM -0500, Carlos Moreno wrote: > obvious question: is there a way to make incremental backup? Not really, at the moment. Sorry. It's supposed to be coming soon (see my other message about PITR). > my system *freezes* until pg_dump finishes. When I say "system", > Is this normal? Is there any way to avoid it? (I guess if I No, it's not normal. I think some additional digging is needed. One thing that is important is to make sure your pg_dump doesn't cause swapping on the machine. Causing swapping is easy if you have been too aggressive in shared-memory allocation for the postmaster, and your OS is careless about who gets to be a candidate for paging. (Solaris 7.1 without priority paging was subject to this problem, for instance). A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110