pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_dump and pg_dumpall is hanging
3+ messages / 3 participants
[nested] [flat]

* pg_dump and pg_dumpall is hanging
@ 2007-03-06 20:20  Karthikeyan Sundaram <skarthi98@hotmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Karthikeyan Sundaram @ 2007-03-06 20:20 UTC (permalink / raw)
  To: pgsql-admin

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_te...




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: pg_dump and pg_dumpall is hanging
@ 2007-03-11 02:44  Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
  parent: Karthikeyan Sundaram <skarthi98@hotmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Rajesh Kumar Mallah @ 2007-03-11 02:44 UTC (permalink / raw)
  To: Karthikeyan Sundaram <skarthi98@hotmail.com>; +Cc: pgsql-admin

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.
>
>     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_te...
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: pg_dump and pg_dumpall is hanging
@ 2007-03-12 15:07  Glen W. Mabey <Glen.Mabey@swri.org>
  parent: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Glen W. Mabey @ 2007-03-12 15:07 UTC (permalink / raw)
  To: Karthikeyan Sundaram <skarthi98@hotmail.com>; +Cc: pgsql-admin



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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2007-03-12 15:07 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-03-06 20:20 pg_dump and pg_dumpall is hanging Karthikeyan Sundaram <skarthi98@hotmail.com>
2007-03-11 02:44 ` Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
2007-03-12 15:07   ` Glen W. Mabey <Glen.Mabey@swri.org>

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