Re: Lot of postmaster processes

[Ron Johnson <ronljohnsonjr@xxxxxxxxx>]

pg_ctl status -D /pgdata/pgsql/15/data

Sorry about that.

On Fri, Dec 20, 2024 at 3:23 AM kaido vaikla <kaido.vaikla@xxxxxxxxx> wrote:

Actually this problem popped up and disappeared. 
What did you expect to see executing  "pg_ctl -D /pgdata/pgsql/15/data" without any controll option a'la stop etc
br
Kaido

On Tue, 17 Dec 2024 at 20:59, Ron Johnson <ronljohnsonjr@xxxxxxxxx> wrote:

On Tue, Dec 17, 2024 at 1:42 PM kaido vaikla <kaido.vaikla@xxxxxxxxx> 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!

--

Death to <Redacted>, and butter sauce.

Don't boil me, I'm still alive.

<Redacted> lobster!