Re: [GENERAL] Backend process is still runs even postmaster got killed

On Fri, Dec 7, 2012 at 10:21 AM, Alvaro Herrera wrote: >>Hari Babu wrote: >> Backend processes are still running even if the postmaster got killed and >> all other server processes are exited by checking the >> >> Postmaster status. >What server version? I had tested it in 9.3 devel and 9.2 as

Re: [GENERAL] Backend process is still runs even postmaster got killed

Hari Babu wrote: > Backend processes are still running even if the postmaster got killed and > all other server processes are exited by checking the > > Postmaster status. What server version? -- Álvaro Herrerahttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, T

Re: [GENERAL] Backend process is still runs even postmaster got killed

>On Fri, Dec 7, 2012 at 7:26 PM, Thalis Kalfigkopoulos wrote: >>On Fri, Dec 7, 2012 at 10:21 AM, Hari Babu < haribabu(dot)komm(at)huawei(dot)com> wrote: >>Backend processes are still running even if the postmaster got killed and all other server processes are e

Re: [GENERAL] Backend process is still runs even postmaster got killed

On Fri, Dec 7, 2012 at 10:21 AM, Hari Babu wrote: > Backend processes are still running even if the postmaster got killed and > all other server processes are exited by checking the > > Postmaster status. > > ** ** > > And the backend process is providing the service to the client. >

[GENERAL] Backend process is still runs even postmaster got killed

Backend processes are still running even if the postmaster got killed and all other server processes are exited by checking the Postmaster status. And the backend process is providing the service to the client. Is there any problems are possible? If we continue the system for a long time wi

Re: [GENERAL] Backend process that won't die

-Original Message- > From: Tom Lane [mailto:t...@sss.pgh.pa.us] > Sent: Tuesday, September 06, 2011 9:57 AM > To: Susan Cassidy > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Backend process that won't die > Susan Cassidy writes: >> I have

Re: [GENERAL] Backend process that won't die

Susan Cassidy writes: > I have a couple of backend processes that are "stuck", and do not respond to > a pg_cancel_backend. This is PostgreSQL 8.3.5. The pg_cancel_backend > returns true, but the process keeps running. I have also done a "kill 12345" > from the command-line, with no effect.

[GENERAL] Backend process that won't die

I have a couple of backend processes that are "stuck", and do not respond to a pg_cancel_backend. This is PostgreSQL 8.3.5. The pg_cancel_backend returns true, but the process keeps running. I have also done a "kill 12345" from the command-line, with no effect. The processes are running a "s

Re: [GENERAL] backend process terminates

On Wed, Aug 08, 2007 at 08:50:41AM -0400, Geoffrey wrote: > Correct on both counts. Many of the routines are wrapper routines used > to assist in code portability. That ok in programs, but shared libraries need to be careful not to use names likely to be used by programs that use them. FWIW, thi

Re: [GENERAL] backend process terminates

Martijn van Oosterhout wrote: On Tue, Aug 07, 2007 at 07:46:45AM -0400, Geoffrey wrote: I don't know all the idiosyncrasies of how this works, so bear with me on this. The developer at the vendor indicated that he's narrowed down the problem to a set of wrapper routines in their code. They ar

Re: [GENERAL] backend process terminates

On Tue, Aug 07, 2007 at 07:46:45AM -0400, Geoffrey wrote: > I don't know all the idiosyncrasies of how this works, so bear with me > on this. The developer at the vendor indicated that he's narrowed down > the problem to a set of wrapper routines in their code. They are named > OpenFile(), Clo

Re: [GENERAL] backend process terminates

Tom Lane wrote: Geoffrey Myers <[EMAIL PROTECTED]> writes: The output from the gdb batch process may be found here: http://www.serioustechnology.com/gdbbatch.txt gdb isn't telling you the whole truth, evidently --- how'd control get from line 781 to 912 with nothing in between? Recompiling th

Re: [GENERAL] backend process terminates

Tom Lane wrote: Geoffrey Myers <[EMAIL PROTECTED]> writes: The output from the gdb batch process may be found here: http://www.serioustechnology.com/gdbbatch.txt gdb isn't telling you the whole truth, evidently --- how'd control get from line 781 to 912 with nothing in between? Recompiling th

Re: [GENERAL] backend process terminates

Geoffrey Myers <[EMAIL PROTECTED]> writes: > The output from the gdb batch process may be found here: > http://www.serioustechnology.com/gdbbatch.txt gdb isn't telling you the whole truth, evidently --- how'd control get from line 781 to 912 with nothing in between? Recompiling the backend with -

[GENERAL] backend process terminates

We've been wrestling with a problem where the backend process terminates with a SEGSEGV. We are having a hard time tracking this thing down, so I decided to run a batch gdb process that single steps through the code until it crashes and post the output to the list for a request for assistance.

Re: [GENERAL] backend process

Scott Marlowe <[EMAIL PROTECTED]> writes: > On Wed, 2005-03-23 at 10:11, Edson Vilhena de Carvalho wrote: >> active backend server processes. I would like to know >> what is a active backend server processes. > In PostgreSQL every connection spawns a new backend that operates on the > database sem

Re: [GENERAL] backend process

On Wed, 2005-03-23 at 10:11, Edson Vilhena de Carvalho wrote: > I'm a new user of postgreSQL > > I was loking at the documentation and testing some > things and I make: > > select * from pg_stat_database; > > pg_stat_database is writen on the table of page 317, > one os the outputs is numbackend

[GENERAL] backend process

I'm a new user of postgreSQL I was loking at the documentation and testing some things and I make: select * from pg_stat_database; pg_stat_database is writen on the table of page 317, one os the outputs is numbackends that is the number of active backend server processes. I would like to know wh