Search Postgresql Archives

Re: How to release locks

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I find that my killed connection server process process disappear in Status 
after a long time.

> If pgAdmin's cancel is just dropping the connection, the server might 
> take some time to notice it, especially if it's in the process of  running 
> a query and doesn't have reason to talk to pgAdmin.

I think pgAdmin sends cancel command through postgres server main process. 
So server
receives it immediately and sends it immediately to selected child process.

I don't have an idea what pgadmin cancel command exactly does.
After executing it processes remain visible in Status pane always.
I set log_statement = 'all'  in postgres.conf file but cancel command does 
not wrote any entry to log file.

There is also Terminate button in Status panel but it is always disabled. I 
havent found way to enable it. 




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux