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:

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

2019-08-20 Thread Andreas Joseph Krogh
På tirsdag 20. august 2019 kl. 22:32:25, skrev chiru r mailto:chir...@gmail.com>>: 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. We did not find any references in logs. [...]

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

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

2019-08-20 Thread chiru r
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. We did not find any references in logs. Please provide your advice and help on this issue. DB version : PostgreSQL *9.5.10* Se