chiru r wrote:
> I have observed one of our PostgreSQL DB instance showing two postgres process on Linux server as highlighted. The
secondpostgres 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
> postgres 33438 1 0 12:41 ? 00:00:03 /u01/postgres/9.5/bin/postgres -D /u02/pgdata01/9.5/data
> [...]
> postgres 110181 33438 0 15:30 ? 00:00:00 /u01/postgres/9.5/bin/postgres -D /u02/pgdata01/9.5/data
Perhaps it is a new client connection, and the process title just hasn't been changed (yet).
What is your setting for "update_process_title"?
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com