Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9AD824766DF for ; Fri, 24 Jan 2003 10:26:32 -0500 (EST) Received: from VL-MS-MR002.sc1.videotron.ca (relais.videotron.ca [24.201.245.36]) by postgresql.org (Postfix) with ESMTP id 85311477182 for ; Fri, 24 Jan 2003 10:17:54 -0500 (EST) Received: from mochima.com ([66.131.15.233]) by VL-MS-MR002.sc1.videotron.ca (iPlanet Messaging Server 5.2 HotFix 0.9 (built Jul 29 2002)) with ESMTP id <0H98008GU55V58@VL-MS-MR002.sc1.videotron.ca> for pgsql-performance@postgresql.org; Fri, 24 Jan 2003 10:17:55 -0500 (EST) Date: Fri, 24 Jan 2003 10:16:42 -0500 From: Carlos Moreno Subject: Having trouble with backups (was: Re: Crash Recovery) Cc: PgSQL Performance ML Message-id: <3E3158DA.7080807@mochima.com> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-transfer-encoding: 7BIT X-Accept-Language: en-us User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.4.1) Gecko/20020508 Netscape6/6.2.3 References: <2147483647.1043361178@[10.0.1.133]> <1043416377.29437.70.camel@haggis> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/281 X-Sequence-Number: 928 Speaking about daily backups... We are running into some serious trouble with our backup policy. First (and less important), the size of our backups is increasing a lot; yet information is not changing, only being added; so, the obvious question: is there a way to make incremental backup? And the second (and intriguing) problem: whenever I run pg_dump, my system *freezes* until pg_dump finishes. When I say "system", I mean the software that is running and sending data to the PG database. It just freezes, users are unable to connect during several minutes, and the ones already connected think the server died, so they end up disconnecting after one or two minutes seeing that the server does not respond. Is this normal? Is there any way to avoid it? (I guess if I have a solution to the first problem -- i.e., doing incremental backups -- then that would solve this one, since it would only "freeze" the system for a few seconds, which wouldn't be that bad...) Thanks for any comments! Carlos --