Re: 3 postgres processes

--- On Tue, 9/9/08, Markova, Nina <nmarkova@NRCan.gc.ca> wrote:

> From: Markova, Nina <nmarkova@NRCan.gc.ca>
> Subject: [GENERAL] 3 postgres processes
> To: pgsql-general@postgresql.org
> Date: Tuesday, September 9, 2008, 2:50 PM
> Hi,
>
> After issuning initdb and starting the postgres server, I
> checked for processes running, expecting to see just one:
>
> postgres  4926  4924   0 14:44:52 ?           0:00
> /usr/postgres/8.2/bin/postgres
> postgres  4924     1   0 14:44:52 pts/1       0:00
> /usr/postgres/8.2/bin/postgres
> postgres  4929  4850   0 14:44:56 pts/1       0:00 grep
> postgres
> postgres  4928  4850   0 14:44:56 pts/1       0:00 ps -ef
> postgres  4927  4924   0 14:44:52 ?           0:00
> /usr/postgres/8.2/bin/postgres
>
>
> Only one of them is in postmaster.pid. What the other ones
> are for?
>
>  more /pg_data/postmaster.pid
> 4924
> /pg_data
>   5432001        31
>
>
> Thanks,
>

use ps auxw to see more details of the process

i think the processes are one of this

writer process
wal writer process
autovacuum launcher process
stats collector process