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

2019-08-21 Thread Laurenz Albe
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 : Postg

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

2019-08-20 Thread Steve Crawford
FWIW, the second process (110181) is a child of the main process (33438). I can't recall if any maintenance process that gets automatically activated (autovacuum, checkpoint, stats, etc.) shows with the same name as the main process. Cheers, Steve On Tue, Aug 20, 2019 at 1:32 PM chiru r wrote:

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

2019-08-20 Thread Steve Crawford
(sorry for the top-post - blame GMail) -Steve >

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

2019-08-20 Thread chiru r
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/p

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

2019-08-20 Thread Adrian Klaver
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 th