Re: Multiple Postgres process are running in background

On 8/13/21 3:20 AM, Ram Charan Kallem wrote:
> Hi,
> 
> We are using Postgres 10 (Single client)and observed that there are 
> multiple PostgreSQL Server process are running in background.
> 
> Why these additional process are created  or is this an expected behavior.

Yes. From my Linux machine:

  ps ax | grep postgres
   818 ?        Ss     0:00 /usr/local/pgsql12/bin/postgres -D 
/usr/local/pgsql12_test/data
   906 ?        Ss     0:00 /usr/local/pgsql12/bin/postgres -D 
/usr/local/pgsql12/data
   954 ?        Ss     0:00 postgres: logger
   982 ?        Ss     0:00 postgres: logger
   984 ?        Ss     0:00 postgres: checkpointer
   985 ?        Ss     0:00 postgres: background writer
   986 ?        Ss     0:00 postgres: walwriter
   987 ?        Ss     0:00 postgres: autovacuum launcher
   988 ?        Ss     0:00 postgres: stats collector
   989 ?        Ss     0:00 postgres: logical replication launcher
  1001 ?        Ss     0:00 postgres: checkpointer
  1002 ?        Ss     0:00 postgres: background writer
  1003 ?        Ss     0:00 postgres: walwriter
  1004 ?        Ss     0:00 postgres: autovacuum launcher
  1005 ?        Ss     0:00 postgres: stats collector
  1006 ?        Ss     0:00 postgres: logical replication launcher
  7204 pts/0    S+     0:00 psql -d test -U postgres
  7205 ?        Ss     0:00 postgres: postgres test [local] idle
  7250 pts/1    S+     0:00 psql -d production -U postgres -p 5442
  7251 ?        Ss     0:00 postgres: postgres production [local] idle
  7296 pts/2    S+     0:00 grep --color=auto postgres

There are background processes that run as well as process for each 
connection.

> 
> Regards,
> 
> RamCharan
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com