Actually I'm writing emails on my Mac <g> However, the Postgres service is running on my Windows 2003 machine..
The disk space issue turned out to be a disk quota which was easy to solve. Unfortunately, the fact it crashed Postgres and with a massive transaction log left the server in a state where it wouldn't boot anymore. I was eventually able to fix it by resetting the transaction log manually. I'm hoping future versions of Postgres will handle this scenario a lot better..
Mike Grzegorz Jaśkiewicz wrote:
I bet it is on windows (judging by html in that email), but if isn't: open a console and issue: watch -n 0.5 df -h and run that insert again ;)
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general