Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 554559FB658 for ; Sat, 10 Mar 2007 22:44:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 45324-01 for ; Sat, 10 Mar 2007 22:44:35 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.244]) by postgresql.org (Postfix) with ESMTP id 170A89FB45C for ; Sat, 10 Mar 2007 22:44:40 -0400 (AST) Received: by an-out-0708.google.com with SMTP id c24so1011286ana for ; Sat, 10 Mar 2007 18:44:39 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=GzBC8r9ZWXWmnHUttlYEjOwO806xLuhOezNBLeuKeZ2/svycr1u36hPN8l1XZRcUMsYrlksdNgmT10WumyAlS2ScONo0VNKSwkmmgZsW6IjeQXJeAAc7GceX8FZNBqOzRy6C+wAfvw629J/tZe3+TiXdDdfqIjDZIFTj+9RJw/c= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=N532tDKh9BkHvt3EjMJVOAbHjIug2d9pm6mJloFCctyx82mHQr3ONNDJ71Q97xDh6mjXH5WD0Tz2OX+ZJWchZ6g/kkeagPYmzutH+4qSLZnaCCtnDSv7z2BHRpY9OEYuW9wFPdTxqIhDugbTDaNs6lBTYn/845fsW2NWBfiN3A8= Received: by 10.114.80.4 with SMTP id d4mr681861wab.1173581078697; Sat, 10 Mar 2007 18:44:38 -0800 (PST) Received: by 10.114.176.15 with HTTP; Sat, 10 Mar 2007 18:44:38 -0800 (PST) Message-ID: Date: Sun, 11 Mar 2007 08:14:38 +0530 From: "Rajesh Kumar Mallah" To: "Karthikeyan Sundaram" Subject: Re: pg_dump and pg_dumpall is hanging Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <6992E470F12A444BB787B5C937B9D4DF09A4CBA4@ca-mail1.cis.local> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/57 X-Sequence-Number: 24881 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. > > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org >