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
