Re: pg_dump on windows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"dghundt@xxxxxxxxxxx" <dghundt@xxxxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux