Re: ERROR: canceling query due to user request - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: canceling query due to user request
Date
Msg-id 1197.1094571579@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: canceling query due to user request  ("Andrew Janian" <ajanian@scottrade.com>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: supressing NOTICE messages on Windows/cygwin only not working?
Next
From: Oliver Elphick
Date:
Subject: Re: restricting non superuser from accessing other