"Hussain Jawad-FXRM43" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
