I restart postmaster. Keep in mind this is only in development. I am using a postgres manager (EMS PostgreSQL Manager 2 http://ems-hitech.com/pgmanager/) and that is where I am seeing this problem. I was sure there were better ways to solve it than restarting, but I am not worried since we do not have this problem with any production databases.
The DB is a Debian machine running postgreSQL 7.4.2. Thanks, Andrew -----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 07, 2004 10:40 AM To: Andrew Janian Cc: Tore Halset; [EMAIL PROTECTED] Subject: Re: [GENERAL] ERROR: canceling query due to user request "Andrew Janian" <[EMAIL PROTECTED]> writes: > I am experiencing a similar problem with PostgreSQL running on Debian. > I am not doing anything special when it happens, just once and a > while. It is not a production system (on which this problem does not > occur) so I just restart and everything is fine. Restart? Do you actually need to restart to make the problem stop? If so, do you mean restarting the PG postmaster, or rebooting the whole machine? Would maybe just starting a fresh backend (psql session) make the problem stop? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster