Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 194209FB543 for ; Mon, 12 Mar 2007 12:07:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 06213-08 for ; Mon, 12 Mar 2007 12:07:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from virus89-out.ccf.swri.edu (virus89-out.ccf.swri.edu [129.162.252.34]) by postgresql.org (Postfix) with ESMTP id 168BE9FB2C6 for ; Mon, 12 Mar 2007 12:07:42 -0300 (ADT) Received: from gwmdc1293linux (localhost [127.0.0.1]) by virus89-out.ccf.swri.edu (8.13.1/8.13.1) with ESMTP id l2CF7c3e014512; Mon, 12 Mar 2007 10:07:38 -0500 (CDT) Date: Mon, 12 Mar 2007 10:07:38 -0500 From: "Glen W. Mabey" To: Karthikeyan Sundaram Cc: pgsql-admin@postgresql.org Subject: Re: pg_dump and pg_dumpall is hanging Message-ID: <20070312150738.GB32491@bams.ccf.swri.edu> References: <6992E470F12A444BB787B5C937B9D4DF09A4CBA4@ca-mail1.cis.local> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/67 X-Sequence-Number: 24891 On Sun, Mar 11, 2007 at 08:14:38AM +0530, Rajesh Kumar Mallah wrote: > have you used the verbose option by adding a couple of -v with > pg_dump or pg_dumpall ? try it it may give a hit > > regds > mallah > > On 3/7/07, Karthikeyan Sundaram wrote: > >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. I had what sounds like a similar problem and finally resolved it by running "reindex index pg_class_relname_nsp_index". The problem appeared for me at the time I upgraded from 8.1.6 to 8.1.8 via Debian testing. Hope that helps, Glen