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

Em sex., 13 de ago. de 2021 às 11:55, Ram Charan Kallem <
RamCharan.Kallem@non.se.com> escreveu:

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.

This is a normal and expected behavior.

pgsql-hackers@, is not an appropriate place to such questions.

regards,
Ranier Vilela