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(dot)klaver(at)aklaver(dot)com