Thread: 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