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 1tOYIf-0077VO-Il for pgsql-admin@arkaria.postgresql.org; Fri, 20 Dec 2024 08:23:58 +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 1tOYIe-007DkD-PV for pgsql-admin@arkaria.postgresql.org; Fri, 20 Dec 2024 08:23:56 +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 1tOYIe-007Div-7w for pgsql-admin@lists.postgresql.org; Fri, 20 Dec 2024 08:23:56 +0000 Received: from mail-qv1-xf2d.google.com ([2607:f8b0:4864:20::f2d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tOYIX-000WKX-NM for pgsql-admin@postgresql.org; Fri, 20 Dec 2024 08:23:54 +0000 Received: by mail-qv1-xf2d.google.com with SMTP id 6a1803df08f44-6d8e8445219so14217316d6.0 for ; Fri, 20 Dec 2024 00:23:49 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734683028; x=1735287828; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=1qRn2AoMUw4b3/JcRS5MvsuZfXKqwuPvttVeAr/whn0=; b=c/LH5WGTsWHEOxPljC4yk/a0KuiMQK6sJL8rhoorHaZZ79nt6fWxM025qR4/Txub2B ISmzxu9x6/WRgdPraQFa7rSPoNFTFb7tbPXILaaPmvNHLnqpYhiE44/FR0X5zu1eVqD9 O93mNMd9QsMxEnpw5X1Pppz6x2F/LMs+VZzGo/BPm0br+kRdxvHXBBncc4ymUGR1LhzH eZ8nE/pPHPtu6MqJg2DuQeZvb0C+4aG23ZNtWDdLhUoAza5WPTP8oFbfxIrbFIQWJocm pqTaTgil8gk+4Thb4MIhXprbcp+O1WVMshX4pAMCfgxlhlWdIUY6FouUoHx7lC3YCLWG ITUA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734683028; x=1735287828; h=cc: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=1qRn2AoMUw4b3/JcRS5MvsuZfXKqwuPvttVeAr/whn0=; b=nQ3GYCZyZbA9cRyKtl7ZM6nbgW+t4SgZPmyj4DnsQIsLsNr3uNoU6cLUBr/eAyXlfe hK74QOFHI6eUKnHsCGcqBAI9NxXdZVQ0UGDnD2OM4bAtWKcJE25PapCPTO6HOHZ322QT KVy4c9I/7hNi6fZnw9ZEa/8LsQ9Hm1wLgekEFCrWPOBI6frH2poBNbjQlUWGurU7vI1H aKqL+4jxlsz3MwUDHnfAkgPEFPx5ELdlTe1SnX9GAAh7+6GwKwyOSgQoZKPrBWUzKmbX NAXvNdtf0yqK4vcCIw0zA7WiqE1H9gR0dUPUsEvj2YzHQYz3kvVondSNb3lmxiHl4U2p ReNA== X-Gm-Message-State: AOJu0YzqSytfDdRX/yxqOrmE/hFt88OjMq47E0wd/4dKF3sPeUer0Rj4 GMgfNH1vMtybyKHWcIOzc5obAS3g7X80cKnUMCvve1v4MqjXNGoqlyvkkWR4QrVGAG3oRRMxO+h /Y7AV8dI+MHFkJwxxko5t2U6g2Wk= X-Gm-Gg: ASbGncuc7Vy16CBlBPT9NQX5GMWVpUKBW2l8AZgPp9Ik3kicI8aq/lJRDrAVuoe4bCU 9hK4bykxM7JgPvqK8eSnPIn2kFDNUMcenVPwndQ== X-Google-Smtp-Source: AGHT+IEU+YMgOlwX5voSuBZHqW4NYkHIV5ecCJLV9MVQ3Q+IMCPwmeEsBll1/Vpk6cjYZOCaBVjI4axygGsepnqxKiU= X-Received: by 2002:a05:6214:3d02:b0:6d4:2806:1765 with SMTP id 6a1803df08f44-6dd233abf3bmr30509986d6.34.1734683028585; Fri, 20 Dec 2024 00:23:48 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: kaido vaikla Date: Fri, 20 Dec 2024 10:23:37 +0200 Message-ID: Subject: Re: Lot of postmaster processes To: Ron Johnson Cc: pgsql-admin Content-Type: multipart/alternative; boundary="000000000000b782100629af5d99" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b782100629af5d99 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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) idl= e >> 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) BE= GIN >> 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! > --000000000000b782100629af5d99 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Actually this problem popped up and disappeared.=C2=A0
What= did you expect to see executing =C2=A0"pg_ctl -D /pgdata/pgsql/15/dat= a" 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 vai= kla <kaido.v= aikla@gmail.com> wrote:
Hi,=C2=A0

Output below is output of comma= nd
=C2=A0
$top -c -= u postgres

Can= somebody tell me why there is so many postmaster running.
O/S: Rocky Li= nux 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=A0S= HR 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 125720= 0 =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.01 postgres: elvnetfix_instance: elvnetfixadmin elvnetfix x.x.x.x(= 8497) idle
2836990 postgres =C2=A020 =C2=A0 0 1261612 =C2=A014556 =C2=A0= 11144 R =C2=A0 0.2 =C2=A0 0.4 =C2=A0 0:01.03 postgres: elvnetfix_instance: = elvnetfixadmin 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 &= quot;pg_ctl -D=C2=A0/pgdata/pgsql/15/data" and "ps -ejH" say= ?


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