Re: [HACKERS] forced to restart postgresql service yesterday

2005-12-08 Thread Merlin Moncure
> Subject: Re: [HACKERS] forced to restart postgresql service yesterday > > "Merlin Moncure" <[EMAIL PROTECTED]> writes: > > The login was hanging in a simple plpgsql login script which basically > > did an insert/update on a small table. It would hang when

Re: [HACKERS] forced to restart postgresql service yesterday

2005-12-08 Thread Tom Lane
"Merlin Moncure" <[EMAIL PROTECTED]> writes: > The login was hanging in a simple plpgsql login script which basically > did an insert/update on a small table. It would hang when called from > within psql, and once hung the query would not respond to cancel > requests (such as they are implemented

[HACKERS] forced to restart postgresql service yesterday

2005-12-08 Thread Merlin Moncure
Yesterday one of our clients called up and complained about lousy performance and being unable to log in to our postgresql 8.0 backed ERP running on windows 2000 server. The server has been run for several months without being restarted or rebooted. The login was hanging in a simple plpgsql login