Re: Lot of postmaster processes

On Tue, Dec 17, 2024 at 1:42 PM kaido vaikla <kaido(dot)vaikla(at)gmail(dot)com> wrote:

> Hi,
>
> Output below is output of command
>
> $top -c -u postgres
>
> Can somebody tell me why there is so many postmaster running.
> O/S: Rocky Linux release 9.4
> pg rel: 15.10
>
> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+
> COMMAND
> 2837351 postgres 20 0 6408 256 256 D 9.8 0.0 0:02.02
> free -h
> 2837291 postgres 20 0 235300 1536 512 R 2.5 0.0 0:03.34 top
> -c -u postgres
> 2837352 postgres 20 0 1257200 2004 128 R 0.8 0.1 0:00.16
> /usr/pgsql-15/bin/postmaster -D /pgdata/pgsql/15/data/
> 2836988 postgres 20 0 1261488 15708 12168 R 0.2 0.4 0:01.01
> postgres: elvnetfix_instance: elvnetfixadmin elvnetfix x.x.x.x(8497) idle
> 2836990 postgres 20 0 1261612 14556 11144 R 0.2 0.4 0:01.03
> postgres: elvnetfix_instance: elvnetfixadmin elvnetfix x.x.x.x(12454) BEGIN
> 2837353 postgres 20 0 1257200 1876 0 R 0.2 0.1 0:00.05
> /usr/pgsql-15/bin/postmaster -D /pgdata/pgsql/15/data/
>
[snip]

What do "pg_ctl -D /pgdata/pgsql/15/data" and "ps -ejH" say?

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!