Tuesday, September 9, 2008

Re: [GENERAL] 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



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

No comments: