Re: pg_dump and pg_dumpall is hanging

From: "Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com>
To: "Karthikeyan Sundaram" <skarthi98(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump and pg_dumpall is hanging
Date: 2007-03-11 02:44:38
Message-ID: a97c77030703101844j618e165ap59ace4c98bb56612@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)hotmail(dot)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_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
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joost Kraaijeveld 2007-03-12 13:20:44 PostgreSQL crashes on Windows 2003
Previous Message Tom Lane 2007-03-10 05:27:06 Re: [GENERAL] index bloat problem