Re: [ADMIN] PostgreSQL hanging

2006-07-31 Thread Dilipkumar
Hi, Try to run a vaccum scripts in the db. Thanks & Regards Dilipkumar - Original Message - From: "Benjamin Krajmalnik" <[EMAIL PROTECTED]> To: Sent: Monday, July 31, 2006 10:04 PM Subject: [ADMIN] PostgreSQL hanging I am runing PG 8.1.4/Windows. Over the we

Re: [ADMIN] PostgreSQL hanging

2006-07-31 Thread Benjamin Krajmalnik
: [ADMIN] PostgreSQL hanging Do you have any antivirus running on your system? if so, try disabling that. This problem can occur if some other process is holding a lock on that specific file and so as a result not able to rename the file.Thanks,-- Shoaib MirEnterpriseDB

Re: [ADMIN] PostgreSQL hanging

2006-07-31 Thread Shoaib Mir
Do you have any antivirus running on your system? if so, try disabling that. This problem can occur if some other process is holding a lock on that specific file and so as a result not able to rename the file. Thanks,-- Shoaib MirEnterpriseDB (www.enterprisedb.com)On 7/31/06, Benjamin Krajmalnik <

[ADMIN] PostgreSQL hanging

2006-07-31 Thread Benjamin Krajmalnik
I am runing PG 8.1.4/Windows. Over the weekend, I have had to restart the PostgreSQL service a couple of times after PG hangs. At the time this happens, the log is showing entries such as the one below 2006-07-31 09:19:55 LOG: could not rename file "pg_xlog/0001020800E1" to "pg_xlog/0