Re: BUG #8161: Several instances of Postgres service

On 5/14/2013 8:48 AM, ranjita(dot)nayak(at)in(dot)abb(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 8161
> Logged by: Ranjita
> Email address:ranjita(dot)nayak(at)in(dot)abb(dot)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