chiru r wrote: > 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 > 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
