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

From: chiru r <chirupg(at)gmail(dot)com>
To: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Two Postgres master process are showing - one is on and off
Date: 2019-08-20 20:32:25
Message-ID: CA+RSxMj88mYDA_R67CzB+9_Ed-ODJmSbxsotMR4WgyPDw7FKAg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)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(at)SERVER1 data]$

Thanks,

Chiru

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-08-20 20:42:34 Re: Two Postgres master process are showing - one is on and off
Previous Message Adrian Klaver 2019-08-20 20:07:31 Re: Rename a column if not already renamed.?