Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 62BD5476FAF for ; Fri, 24 Jan 2003 11:32:16 -0500 (EST) Received: from smtp3.ihug.com.au (smtp3.ihug.com.au [203.109.250.76]) by postgresql.org (Postfix) with ESMTP id 6165F4772E8 for ; Fri, 24 Jan 2003 11:09:04 -0500 (EST) Received: from 203-30-124-221.cust.iweb.net.au (postgresql.org) [203.30.124.221] by smtp3.ihug.com.au with esmtp (Exim 3.22 #1 (Debian)) id 18c6OA-0000re-00; Sat, 25 Jan 2003 03:09:07 +1100 Message-ID: <3E31651C.9060306@postgresql.org> Date: Sat, 25 Jan 2003 02:39:00 +1030 From: Justin Clift User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Carlos Moreno Cc: PgSQL Performance ML Subject: Re: Having trouble with backups (was: Re: Crash Recovery) References: <2147483647.1043361178@[10.0.1.133]> <1043416377.29437.70.camel@haggis> <3E3158DA.7080807@mochima.com> In-Reply-To: <3E3158DA.7080807@mochima.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/284 X-Sequence-Number: 931 Carlos Moreno wrote: > 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 there any chance that you have hardware problems? For example a couple of disk areas that are defective and the system is not happy about, or maybe hard drive controller problems? With PC's, this sort of thing generally seems to mean hardware problems of some sort that are being triggered by PostgreSQL having to run through the entire dataset. Could be caused by I/O load, could be caused by hard drive errors, etc. ? > Is this normal? No. Out of curiosity, which operating system are you using? :-( Regards and best wishes, Justin Clift > 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 > -- > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi