This code stoped server too: postgres=# do $$ unpack p,1x8 $$ language plperlu; server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed. !>
------> > > Hello Dmitry > > > -----Original Message----- > > From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-owne > > r...@postgresql.org] On Behalf Of Dmitry Vasilyev > > Sent: Freitag, 9. Oktober 2015 11:52 > > To: pgsql-hackers@postgresql.org > > Subject: [HACKERS] Postgres service stops when I kill client > > backend on Windows > > > > I’ve started PostgreSQL server on Windows and then I kill client > > backend’s process by taskkill the service was stopped: > > > > postgres=# select pg_backend_pid(); > > pg_backend_pid > > ---------------- > > 1976 > > > > postgres=# \! taskkill /pid 1976 /f > > SUCCESS: The process with PID 1976 has been terminated. > > postgres=# select 1; > > server closed the connection unexpectedly > > This probably means the server terminated abnormally > > before or while processing the request. > > The connection to the server was lost. Attempting reset: Failed. > > !> > > > > > > If I kill backend’s process on Linux then service not failing. So > > what’s the problem? Why PostgreSQL is so strange on Windows? > > I can't say what happens on windows, but I don't undestand either why > you want to kill the session you are in. > Besides that why don't you use pg_terminate_backend? > > db=> select pg_backend_pid(); > pg_backend_pid > ---------------- > 8808 > (1 row) > > db=> select pg_terminate_backend(8808); > FATAL: terminating connection due to administrator command > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > The connection to the server was lost. Attempting reset: Succeeded. > db=> select pg_backend_pid(); > pg_backend_pid > ---------------- > 8500 > (1 row) > > Regards > Charles > > > > > > > ------ > > Dmitry Vasilyev > > Postgres Professional: http://www.postgrespro.com > > The Russian Postgres Company > > > > > > -- > > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-hackers > > > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers