on 15/10/01 11:46 am, Ashley @ Turton at ashley@turton.com wrote:
I've been running PostgreSQL for a while on a box here at work. This morning when I logged in, it completes a few queries, then stops progressing them. To complete a few more queries I need to restart postmaster. I have not changed any settings for a long time and it only started playing up today. Any ideas?
I seem to have cured the problem with DROP tables, followed by CREATE. After examining DEBUG outputs from PostgreSQL it was getting stuck on an INSERT SQL command. Odd, perhaps table corruption?
If anyone with PostgreSQL experience could provide an answer (or an insight) into why this happened I would be grateful.
Ashley