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

From: chiru r <chirupg(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Two Postgres master process are showing - one is on and off
Date: 2019-08-20 21:30:44
Message-ID: CA+RSxMiF6aTTbJHCfE69JPLK5efDT5e52CPR9Ac-2mY7wC0KNw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you Adrian.

Is the on/off on a regular interval?
> My guess is a script(cron possibly) is trying to start the server.
>
> Yes, It is regular interval.
No Con-jobs scheduled on server or even remotely.

>
> > 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).
>
> I have verified startup.log and regular postgresql logs also, i did not
found above messages.

Thanks,
Chiru

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2019-08-20 22:00:56 Re: Two Postgres master process are showing - one is on and off
Previous Message Jeff Janes 2019-08-20 21:26:01 Re: Databases and servers