Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 494A19FB4E0 for ; Tue, 6 Mar 2007 16:21:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 24673-07 for ; Tue, 6 Mar 2007 16:20:56 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc1-s33.bay0.hotmail.com (bay0-omc1-s33.bay0.hotmail.com [65.54.246.105]) by postgresql.org (Postfix) with ESMTP id A21309FB60D for ; Tue, 6 Mar 2007 16:20:58 -0400 (AST) Received: from hotmail.com ([65.55.136.94]) by bay0-omc1-s33.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Tue, 6 Mar 2007 12:20:57 -0800 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 6 Mar 2007 12:20:57 -0800 Message-ID: Received: from 65.55.136.123 by by131fd.bay131.hotmail.msn.com with HTTP; Tue, 06 Mar 2007 20:20:56 GMT X-Originating-IP: [67.116.31.14] X-Originating-Email: [skarthi98@hotmail.com] X-Sender: skarthi98@hotmail.com In-Reply-To: <6992E470F12A444BB787B5C937B9D4DF09A4CBA4@ca-mail1.cis.local> From: "Karthikeyan Sundaram" To: pgsql-admin@postgresql.org Subject: pg_dump and pg_dumpall is hanging Date: Tue, 06 Mar 2007 12:20:56 -0800 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 06 Mar 2007 20:20:57.0073 (UTC) FILETIME=[F2BE3E10:01C7602C] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/22 X-Sequence-Number: 24846 Hi, I am using 8.1.0 for my production. The pg_dumpall was working fine on all these days. Suddenly from yesterday, the pg_dumpall command fails. Fails means, it hangs (no dump) is taking place. What may be the problem? Regards skarthi _________________________________________________________________ Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a month. Intro*Terms https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y&search=mortgage_text_links_88_h27f6&disc=y&vers=743&s=4056&p=5117