Re: pg_dump on windows

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "dghundt(at)netzero(dot)net" <dghundt(at)netzero(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump on windows
Date: 2008-02-08 16:42:47
Message-ID: 2169.1202488967@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"dghundt(at)netzero(dot)net" <dghundt(at)netzero(dot)net> writes:
> Postgres backsup the data and 95% of the time sticks at this table and cpu activity drops from 40-60% to about zero. I can stay there for hours before I just have to stop the attempt.

Have you looked into pg_locks to see if something is holding an
exclusive lock on that table? Have you checked to see if there's
still disk activity?

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message dghundt@netzero.net 2008-02-08 18:30:33 pg_dump on windows
Previous Message Tom Lane 2008-02-08 16:35:30 Re: Error on CLUSTER command