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

On 8/20/19 1:32 PM, chiru r 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.

Is the on/off on a regular interval?
My guess is a script(cron possibly) is trying to start the server.

>
> We did not find any references in logs.

The information:

sudo /etc/init.d/postgresql11 start
Starting PostgreSQL: ok
aklaver(at)ranger:~> -2019-08-20 13:40:30.097 PDT-0FATAL: lock file
"postmaster.pid" already exists
-2019-08-20 13:40:30.097 PDT-0HINT: Is another postmaster (PID 1694)
running in data directory "/usr/local/pgsql11/data"?

Is sent to the starting process and does not make it to the server log
as the server is not started(the 'Starting PostgreSQL' notwithstanding).

>
>
> 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
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com