Обсуждение: pg_dump on windows

I am using postgres 8.2.6 on windows xp pro sp2.  Of about 80 tables, one is a large binary table containing over 2gb
ofdata. 

Postgres backsup the data and 95% of the time sticks at this table and cpu activity drops from 40-60% to about zero.  I
canstay there for hours before I just have to stop the attempt.   

We are using a health care record with postgres backend and other people are having the same problem.
_____________________________________________________________
Own the Ultimate Platinum Credit Card. Click here.
http://thirdpartyoffers.netzero.net/TGL2211/fc/Ioyw6ijldJaAPEMcUmOFzZNdfk9TMs4LECG50diB8qzKXj17ZyjcYG/

"dghundt@netzero.net" <dghundt@netzero.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.
Ican 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