pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_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>
2007-03-11 02:44 ` Re: pg_dump and pg_dumpall is hanging Rajesh Kumar Mallah <mallah.rajesh@gmail.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-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 ` Re: pg_dump and pg_dumpall is hanging Glen W. Mabey <Glen.Mabey@swri.org>
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-06 20:20 pg_dump and pg_dumpall is hanging Karthikeyan Sundaram <skarthi98@hotmail.com>
2007-03-11 02:44 ` Re: pg_dump and pg_dumpall is hanging Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
@ 2007-03-12 15:07 ` Glen W. Mabey <Glen.Mabey@swri.org>
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