Re: Start up error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Hussain Jawad-FXRM43" <FXRM43(at)motorola(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Start up error
Date: 2007-11-20 17:18:31
Message-ID: 6532.1195579111@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Hussain Jawad-FXRM43" <FXRM43(at)motorola(dot)com> writes:
> 2)There are several postgresql process running after a failed
> restart.Below are the proccesess

> ps -ef|grep post
> root 730 30758 0 12:22 pts/2 00:00:00 grep post
> postgres 2700 15927 73 12:00 ? 00:16:15 postgres: cscti csctools
> [local] DELETE
> postgres 6706 15927 72 12:00 ? 00:15:42 postgres: cscti csctools
> [local] DELETE
> postgres 14351 15927 69 12:02 ? 00:13:38 postgres: cscti csctools
> [local] DELETE
> postgres 15927 1 0 11:58 ? 00:00:05 /usr/bin/postmaster -p
> 5432 -D /var/lib/pgsql/data
> postgres 15936 15927 0 11:58 ? 00:00:00 postgres: logger process

> postgres 15967 15927 0 11:58 ? 00:00:00 postgres: writer process

> postgres 15968 15927 0 11:58 ? 00:00:00 postgres: stats buffer
> process
> postgres 15969 15968 0 11:58 ? 00:00:00 postgres: stats
> collector process
> postgres 16118 15927 73 11:58 ? 00:17:23 postgres: cscti csctools
> [local] DELETE
> postgres 23600 15927 65 12:08 ? 00:09:25 postgres: cscti csctools
> [local] DELETE

That hardly looks like a "failed restart". I can't help wondering if
you were looking at the wrong log file.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2007-11-20 17:58:21 Re: BUG #3764: Update count returns zero for a view with 'on update' rules when criteria contains updatable field
Previous Message Tom Lane 2007-11-20 17:12:04 Re: BUG #3762: Inherited serials change on dump/restore