I restart postmaster. Keep in mind this is only in development. I am using a postgres manager (EMS PostgreSQL Manager
2http://ems-hitech.com/pgmanager/) and that is where I am seeing this problem. I was sure there were better ways to
solveit 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:tgl@sss.pgh.pa.us]
Sent: Tuesday, September 07, 2004 10:40 AM
To: Andrew Janian
Cc: Tore Halset; pgsql-general@postgresql.org
Subject: Re: [GENERAL] ERROR: canceling query due to user request
"Andrew Janian" <ajanian@scottrade.com> 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