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
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 |