public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-admin <[email protected]>
Subject: Re: Lot of postmaster processes
Date: Fri, 20 Dec 2024 09:25:25 -0500
Message-ID: <CANzqJaDxwbTLnSP0+jnahUNNkm=YurybSAcjOHhe+a_bVw5fnA@mail.gmail.com> (raw)
In-Reply-To: <CA+427g-hJDNa5NPfG+CMhzc3+BXGOQf9bLh5DYHGEEz5CK5tsg@mail.gmail.com>
References: <CA+427g8ZSPLt+jz8OnvG9dyvEHY+oGs+wpdbLq2+Dj0uOyb5KA@mail.gmail.com>
<CANzqJaC5j6L1Z3=UtPTvUCODmprnmnn=d0tjaUGg6csvh-2MaQ@mail.gmail.com>
<CA+427g-hJDNa5NPfG+CMhzc3+BXGOQf9bLh5DYHGEEz5CK5tsg@mail.gmail.com>
pg_ctl *status* -D /pgdata/pgsql/15/data
Sorry about that.
On Fri, Dec 20, 2024 at 3:23 AM kaido vaikla <[email protected]> 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 <[email protected]> wrote:
>
>> On Tue, Dec 17, 2024 at 1:42 PM kaido vaikla <[email protected]>
>> 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!
view thread (4+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Lot of postmaster processes
In-Reply-To: <CANzqJaDxwbTLnSP0+jnahUNNkm=YurybSAcjOHhe+a_bVw5fnA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox