pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Glen W. Mabey <Glen.Mabey@swri.org>
To: Karthikeyan Sundaram <skarthi98@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump and pg_dumpall is hanging
Date: Mon, 12 Mar 2007 10:07:38 -0500
Message-ID: <20070312150738.GB32491@bams.ccf.swri.edu> (raw)
In-Reply-To: <a97c77030703101844j618e165ap59ace4c98bb56612@mail.gmail.com>
References: <6992E470F12A444BB787B5C937B9D4DF09A4CBA4@ca-mail1.cis.local>
	<BAY131-F146ACD2739DE2EB2779BC1B07B0@phx.gbl>
	<a97c77030703101844j618e165ap59ace4c98bb56612@mail.gmail.com>



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 <skarthi98@hotmail.com> 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



view thread (3+ messages)

Message-ID: <20070312150738.GB32491@bams.ccf.swri.edu>
Permalink:  ../20070312150738.GB32491@bams.ccf.swri.edu/
Also on:    postgresql.org/message-id/20070312150738.GB32491@bams.ccf.swri.edu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: Glen.Mabey@swri.org, skarthi98@hotmail.com
  Subject: Re: pg_dump and pg_dumpall is hanging
  In-Reply-To: <20070312150738.GB32491@bams.ccf.swri.edu>
  References: <6992E470F12A444BB787B5C937B9D4DF09A4CBA4@ca-mail1.cis.local> <BAY131-F146ACD2739DE2EB2779BC1B07B0@phx.gbl> <a97c77030703101844j618e165ap59ace4c98bb56612@mail.gmail.com> <20070312150738.GB32491@bams.ccf.swri.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox