Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tOdwk-007khh-NN for pgsql-admin@arkaria.postgresql.org; Fri, 20 Dec 2024 14:25:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tOdwj-00BvBp-Qs for pgsql-admin@arkaria.postgresql.org; Fri, 20 Dec 2024 14:25:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tOdwj-00Bv9m-B1 for pgsql-admin@lists.postgresql.org; Fri, 20 Dec 2024 14:25:41 +0000 Received: from mail-ot1-x335.google.com ([2607:f8b0:4864:20::335]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tOdwg-000Yzm-Cp for pgsql-admin@postgresql.org; Fri, 20 Dec 2024 14:25:39 +0000 Received: by mail-ot1-x335.google.com with SMTP id 46e09a7af769-71df1f45b0cso1343339a34.1 for ; Fri, 20 Dec 2024 06:25:38 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734704737; x=1735309537; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=0sRBCyigxBU0GznKtkoVVCf8w18fm53oo3t2pKqltjg=; b=BNPU2YVt/Q6j+h5ZqmLz8AQQsTjvNxFXpEocyIp6VcjBrcGYUXPrdp7D/qPHYdHUTY Q88OYvPOD2F4m24wY5ZPktzodnzqJcfCu8z8kXlEQJaQX4x3uZETK6IVJtTo2xhh1sBT 5oLqLe0AJucftBYyqU68mcw5JqU2PEpRCaaiuW0Mk3knW9JMf15dc3PDioDhxILUC63P TrxSPr+6gapDiR7DKAKzXAjstCjfAh4eGRV26RD7CJUNKAVl0WybU3kjQ7+0+KtlSVB1 NBRDJSgZKc5U22eQNXXIBRkzzlNAhXaeEuwIt1lIibIZHhGk7EcP+onDz9lc0QEzI9ZM 43zQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734704737; x=1735309537; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=0sRBCyigxBU0GznKtkoVVCf8w18fm53oo3t2pKqltjg=; b=GlEkGTYT/2YIDZaMsMnl1So2qrpuZUzKl8qEP/bWtuiEl6dTDSwBVyKI9sb+pNhN4x xcmDpyKjKhbRG8dvTQSipcy210RsB+hP0eLd5ZNeHSCWXTplKWFcccqN/5cf8iwI9Gsb RQEGfchNWIKm9z+hjGgVbCFeazWdO6onvHrdZkavQAZRoHigg4CevWmeWyBZL4Kidnr9 PGb642+o5S/wwT7merbJiSi6dKgT5IlSDHSquF/UwDBwXgHYEbnzaly28VqbLlIiXxuN 3sCgiuUXwDPnax+nxNE8QNOt3+2ru6IOc1tJIfD7vh1h6vIKt8Hq66yh1AyLd/JpgoL6 9uGg== X-Gm-Message-State: AOJu0YyX6/Pg8PYHl+sIn3ZaxVIOWz5fDEeAO9T57WQG1Xz7zTaRExGv hJH9md2nLI0rnVg3C1pknGOLBcVnPlkobm1jMqe0E+8aSLwIGNNZpZSmwpvSaFmQYa1cNagshGD v9elViSGKRzh6l43N4+nIOOY75QesPojz X-Gm-Gg: ASbGncvD8cS1ko/DlRpPoCbvRFhn5nWLqjtoZrxWKYA1asjooG7U3uYxptU25G7oz2L Ga6M4TBIJRhVRFScf4HswFuCQuFuQ/djnZ2wBExw= X-Google-Smtp-Source: AGHT+IHP68W3CZTz02MYYxh4bOePcw4AYV/MFExGFCtOohCU9eA/EoPxeYNXxd65pMAEj9FjR0f36Nhca9LNVr2PY2M= X-Received: by 2002:a05:6870:3312:b0:29f:d993:a4cb with SMTP id 586e51a60fabf-2a7d14719d1mr4174630fac.14.1734704736984; Fri, 20 Dec 2024 06:25:36 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Fri, 20 Dec 2024 09:25:25 -0500 Message-ID: Subject: Re: Lot of postmaster processes To: pgsql-admin Content-Type: multipart/alternative; boundary="000000000000a366d40629b46b0e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a366d40629b46b0e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable pg_ctl *status* -D /pgdata/pgsql/15/data Sorry about that. On Fri, Dec 20, 2024 at 3:23=E2=80=AFAM kaido vaikla 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 wrote= : > >> On Tue, Dec 17, 2024 at 1:42=E2=80=AFPM kaido vaikla >> 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) id= le >>> 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) B= EGIN >>> 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 , and butter sauce. >> Don't boil me, I'm still alive. >> lobster! >> > --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000a366d40629b46b0e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
pg_ctl status -D /pgdata/pgsql/15/data

<= /div>
Sorry about that.

On Fri, Dec 20, 2024 at 3:= 23=E2=80=AFAM kaido vaikla <ka= ido.vaikla@gmail.com> wrote:
Actually this problem popped up and disappeared.=C2=A0
What did= you expect to see executing =C2=A0"pg_ctl -D /pgdata/pgsql/15/data&qu= ot; without any controll option a'la stop etc
br
Kaido


On Tue, 17 Dec 2024 at 20:59, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
=
On Tue, Dec 17, 2024 at 1:42=E2=80=AFPM kaido vaikla <<= a href=3D"mailto:kaido.vaikla@gmail.com" target=3D"_blank">kaido.vaikla@gma= il.com> wrote:
Hi,=C2=A0

Output below is output of command
<= div style=3D"font-family:monospace,monospace">=C2=A0
$top -c -u postgre= s

Can somebody= tell me why there is so many postmaster running.
O/S: Rocky Linux relea= se 9.4
pg rel: =C2=A015.10

=C2=A0 =C2=A0 PID USER =C2=A0 =C2=A0 = =C2=A0PR =C2=A0NI =C2=A0 =C2=A0VIRT =C2=A0 =C2=A0RES =C2=A0 =C2=A0SHR S =C2= =A0%CPU =C2=A0%MEM =C2=A0 =C2=A0 TIME+ COMMAND
2837351 postgres =C2=A020= =C2=A0 0 =C2=A0 =C2=A06408 =C2=A0 =C2=A0256 =C2=A0 =C2=A0256 D =C2=A0 9.8 = =C2=A0 0.0 =C2=A0 0:02.02 free -h
2837291 postgres =C2=A020 =C2=A0 0 =C2= =A0235300 =C2=A0 1536 =C2=A0 =C2=A0512 R =C2=A0 2.5 =C2=A0 0.0 =C2=A0 0:03.= 34 top -c -u postgres
2837352 postgres =C2=A020 =C2=A0 0 1257200 =C2=A0 = 2004 =C2=A0 =C2=A0128 R =C2=A0 0.8 =C2=A0 0.1 =C2=A0 0:00.16 /usr/pgsql-15/= bin/postmaster -D /pgdata/pgsql/15/data/
2836988 postgres =C2=A020 =C2= =A0 0 1261488 =C2=A015708 =C2=A012168 R =C2=A0 0.2 =C2=A0 0.4 =C2=A0 0:01.0= 1 postgres: elvnetfix_instance: elvnetfixadmin elvnetfix x.x.x.x(8497) idle=
2836990 postgres =C2=A020 =C2=A0 0 1261612 =C2=A014556 =C2=A011144 R = =C2=A0 0.2 =C2=A0 0.4 =C2=A0 0:01.03 postgres: elvnetfix_instance: elvnetfi= xadmin elvnetfix x.x.x.x(12454) BEGIN
2837353 postgres =C2=A020 =C2=A0 0= 1257200 =C2=A0 1876 =C2=A0 =C2=A0 =C2=A00 R =C2=A0 0.2 =C2=A0 0.1 =C2=A0 0= :00.05 /usr/pgsql-15/bin/postmaster -D /pgdata/pgsql/15/data/
[snip]=C2=A0

What do "pg_= ctl -D=C2=A0/pgdata/pgsql/15/data" and "ps -ejH" say?
<= /div>


--
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> lobs= ter!
--000000000000a366d40629b46b0e--