We're developing a java app and are using postgres as the database. On
our dev server I started the app, closed it, but the java process was
still open so I killed it, which caused the above error. I've had to do
this in the past but have not had this happen before. I've searched the
archives and found a message/reply from Andrew Sullivan about this which
implies that it may be more a file system problem. We're using
postgresql 7.4.1 on a debian box (and yes, ext2). And fsync is turned on.
Aside from not killing processes which hang, is there anything I can do
to avoid this problem in the future?
Thanks
Ron