Re: BUG #8161: Several instances of Postgres service

On 5/14/2013 8:48 AM, ranjita.nayak@in.abb.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      8161
> Logged by:          Ranjita
> Email address:ranjita.nayak@in.abb.com
> PostgreSQL version: 9.2.4
> Operating system:   Windows7
> Description:
>
> Why multiple instances of postgres is running in task manager (around 10nos)
> if we open the PgAdminIII ?

this is not a bug and should not have been reported as such.

postgres uses a number of processes, the postmaster, the writer, the WAL
writer, the checkpointer, the logger, autovacuum launcher, stats
collector, plus a process for each user connection.    on a typical unix
system, with one user connection active, I see 8 processes active at
present...

postgres 38425     1  0 01:59 ?        00:00:00
/usr/pgsql-9.2/bin/postmaster -p 5433 -D /data_lightning/pgsql/data
postgres 38427 38425  0 01:59 ?        00:00:00 postgres: logger process
postgres 38429 38425  0 01:59 ?        00:02:18 postgres: checkpointer
process
postgres 38430 38425  0 01:59 ?        00:00:13 postgres: writer process
postgres 38431 38425  0 01:59 ?        00:00:03 postgres: wal writer
process
postgres 38432 38425  0 01:59 ?        00:00:00 postgres: autovacuum
launcher process
postgres 38433 38425  0 01:59 ?        00:00:09 postgres: stats
collector process
postgres 39450 38425 85 05:38 ?        01:49:02 postgres: postgres
pgbench [local] ALTER TABLE


--
john r pierce                                      37N 122W
somewhere on the middle of the left coast