Re: Two Postgres master process are showing - one is on and off

[Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx>]

FWIW, the second process (110181) is a child of the main process (33438). I can't recall if any maintenance process that gets automatically activated (autovacuum, checkpoint, stats, etc.) shows with the same name as the main process.

Cheers,

Steve

On Tue, Aug 20, 2019 at 1:32 PM chiru r <chirupg@xxxxxxxxx> wrote:

Hi All,

 

I have observed one of our PostgreSQL DB instance showing two postgres process on Linux server as highlighted. The second postgres process is on and off.

We did not find any references in logs.

Please provide your advice and help on this issue.

DB version :  PostgreSQL  9.5.10

Server version   :  RHEL 7.6

 

[postgres@PGSERVER data]$ ps -ef|grep postgres

root       5922   5875  0 Jul31 pts/0    00:00:00 sudo su - postgres

root       5927   5922  0 Jul31 pts/0    00:00:00 su - postgres

postgres   5928   5927  0 Jul31 pts/0    00:00:00 -bash

root      11585  11535  0 11:29 pts/2    00:00:00 sudo su - postgres

root      11606  11585  0 11:29 pts/2    00:00:00 su - postgres

postgres  11607  11606  0 11:29 pts/2    00:00:00 -bash

root      17185  17141  0 Aug19 pts/1    00:00:00 sudo su - postgres

root      17189  17185  0 Aug19 pts/1    00:00:00 su - postgres

postgres  17190  17189  0 Aug19 pts/1    00:00:00 -bash

postgres  33438      1  0 12:41 ?        00:00:03 /u01/postgres/9.5/bin/postgres -D /u02/pgdata01/9.5/data

postgres  33441  33438  0 12:41 ?        00:00:02 postgres: logger process

postgres  33443  33438  0 12:41 ?        00:00:01 postgres: checkpointer process

postgres  33444  33438  0 12:41 ?        00:00:00 postgres: writer process

postgres  33445  33438  0 12:41 ?        00:00:01 postgres: wal writer process

postgres  33446  33438  0 12:41 ?        00:00:00 postgres: autovacuum launcher process

postgres  33447  33438  0 12:41 ?        00:00:01 postgres: stats collector process

postgres  36660  33438  0 12:47 ?        00:00:00 postgres: sj2 devdb 10.220.177.63(57237) idle

root      39915  39837  0 12:53 pts/3    00:00:00 sudo su - postgres

root      39950  39915  0 12:53 pts/3    00:00:00 su - postgres

postgres  39951  39950  0 12:53 pts/3    00:00:00 -bash

postgres 110181  33438  0 15:30 ?        00:00:00 /u01/postgres/9.5/bin/postgres -D /u02/pgdata01/9.5/data

postgres 110183  11607  0 15:30 pts/2    00:00:00 ps -ef

postgres 110184  11607  0 15:30 pts/2    00:00:00 grep --color=auto postgres

[postgres@SERVER1 data]$

 

Thanks,

Chiru