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 1tNcnN-0013t9-Vw for pgsql-admin@arkaria.postgresql.org; Tue, 17 Dec 2024 18:59:50 +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 1tNcnN-005DlS-9F for pgsql-admin@arkaria.postgresql.org; Tue, 17 Dec 2024 18:59:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tNcnM-005DlI-Sf for pgsql-admin@lists.postgresql.org; Tue, 17 Dec 2024 18:59:48 +0000 Received: from mail-oa1-x2c.google.com ([2001:4860:4864:20::2c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tNcnK-000H5N-3g for pgsql-admin@postgresql.org; Tue, 17 Dec 2024 18:59:48 +0000 Received: by mail-oa1-x2c.google.com with SMTP id 586e51a60fabf-29ff5c75c21so11119fac.0 for ; Tue, 17 Dec 2024 10:59:46 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734461984; x=1735066784; 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=I5Aj3owV8eaC+C3eZRt4nIQPw24cY/DE4UpEgBtIXYs=; b=WVfjv/wqI/Ou3Pf5ZZjm9anBt90z2I5n8u9rsTDdEzQpdpQvk5dPou/xi8TvJ/f30y 1NcWdm26Nz4pOyT9o75iXi333kwR3bDv3pEnxc9gA2JWRB7tX7qCrRyiHpE3CifY7F4Z 348GEzXTLV92/96u4wTBp6Z4d1n9kPqBAauWFyIYUWX4TiAYMYhaS5CkJVL9FJ/9KST1 HegxaeqPCZTgwKt5a7Y32V+Hfio4y5H7Ogjkyrifqro0PsQfZcROJCewBvZyDqyV3rsn ZG8YBL1UPUzATWORR2NoLzPqq/IFtrkuhrgJPSAcYSDP/07Rz+9KBB7um4u9QvztTks/ TSRA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734461984; x=1735066784; 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=I5Aj3owV8eaC+C3eZRt4nIQPw24cY/DE4UpEgBtIXYs=; b=TlH6cPPHKbUxol47fXwWPAahqB25fV4TVNbPvUedkaX5jAd+EZgrzI4BbOujjFdBxo ImVHOqV61gHUUJrK2/rbm05EcDXE2ryQYNt2MXO1t4MCglOXBnwT/Waa/9R19qTO4ClB mg/RG0DNo1PdLtNLeqAYOb96gNZc4bViwWleL/q6nL1zoQugteZsjMvTge2N9oG1BXpd K0cjzXcr49Vx0ggFy9ONiwYzWEs0YGYf79HuR1TtLnieYTwRcGD2xwT19GtY1xloohDn q/Yt8bKnqW6oCjNu4SUjssMWXr77AJSYzyluON8m2G+qHFLqmKwDUlo+4Vxv6C792wmD Ie3g== X-Gm-Message-State: AOJu0YwYyvIQmv3WsGuhw7yL93kDxVWPMvPhKA80BM06RWTtOBkqEaNf w5kchbxasOQU3CXZZqNfy0QmRD7/6+PjjDBUJHFwaJnnohf/GfE0XYhAHasuWnMGXVETpnlJuoq LRNCbJX8tfjGGzZG3TgLThxu53DSJJEex X-Gm-Gg: ASbGncuhb76oHVzOlv72KGpLcoiFLFfku7Sokzanqq0Eo9Rp2YR7/g4y3FIiibbuDRn 01Mbi+zJeI3Lps9eoBl3uvsLfmrt5AVXJYHjP16zGarguTILKJH2lxWOF+3m/bP0qqjrb+vGl X-Google-Smtp-Source: AGHT+IE/RpwtySDSHVFfDrkV4D2VG2ThiFggNacipP6yUsWoJV9KWnXk8EtHJP2+7lkeIA5qQhZhE7yiZJ1gAIFKILE= X-Received: by 2002:a05:6871:e7c9:b0:2a7:5ce8:820f with SMTP id 586e51a60fabf-2a78a670b43mr2795178fac.9.1734461984163; Tue, 17 Dec 2024 10:59:44 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Tue, 17 Dec 2024 13:59:32 -0500 Message-ID: Subject: Re: Lot of postmaster processes To: pgsql-admin Content-Type: multipart/alternative; boundary="000000000000714e5106297be6fc" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000714e5106297be6fc Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 to= p > -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) BEG= IN > 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? --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000714e5106297be6fc Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, Dec 17, 2024 at 1:42=E2=80=AFPM k= aido vaikla <kaido.vaikla@gmai= l.com> wrote:
=
Hi,=C2=A0

Output below is out= put of command
=C2=A0 <= br>$top -c -u postgres

Can somebody tell me why there is so many postmaster running.
O= /S: Rocky Linux release 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
283= 7351 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 postgre= s =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/
28369= 88 postgres =C2=A020 =C2=A0 0 1261488 =C2=A015708 =C2=A012168 R =C2=A0 0.2 = =C2=A0 0.4 =C2=A0 0:01.01 postgres: elvnetfix_instance: elvnetfixadmin elvn= etfix 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: elvne= tfix_instance: elvnetfixadmin elvnetfix x.x.x.x(12454) BEGIN
2837353 pos= tgres =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?


--
Death to <Redacted>, and butter sa= uce.
Don't boil me, I'm still alive.
<Redacted&= gt; lobster!
--000000000000714e5106297be6fc--