What's causing my postgresql database to freeze?
Turns out the issue was the format of the external HD.  It was in NTFS, which was accessed via Paragon NTFS, and for whatever reason the connection would simply screw up after a few hours.  I reformatted the external HD into Mac OS Extended (Journaled) format and all problems went away.