Re: Multiple postmasters running from same directory

2018-02-13 Thread Tom Lane
Vikas Sharma writes: > So is it normal for postgres to fork out new postmaster processes from the > same data directory? I haven't seen this earlier. They're not postmasters, they're child processes, as you can easily tell from the PID/PPID columns of your ps output. But a

Re: Multiple postmasters running from same directory

2018-02-13 Thread Vikas Sharma
Thanks Tom, So is it normal for postgres to fork out new postmaster processes from the same data directory? I haven't seen this earlier. I will check from where those connection requests are coming in, Best Regards Vikas On Feb 13, 2018 15:50, "Tom Lane" wrote: > Laurenz

Re: Multiple postmasters running from same directory

2018-02-13 Thread Tom Lane
Francisco Olarte writes: > On Tue, Feb 13, 2018 at 4:50 PM, Tom Lane wrote: >> Putting two and two together, you have some monitoring program that is >> hitting the postmaster with a constant stream of TCP connection requests >> none of which get

Re: Multiple postmasters running from same directory

2018-02-13 Thread Tom Lane
Laurenz Albe writes: > Vikas Sharma wrote: >> On the master I can see multiple postmaster processes from the same data >> directory. >> ps -ef |grep -i postgres|grep postm >> postgres 81440 1 0 Jan31 ?00:11:37 >> /usr/pgsql-9.4/bin/postmaster -D

Re: Multiple postmasters running from same directory

2018-02-13 Thread Laurenz Albe
Vikas Sharma wrote: > We are running Postgresql 9.4 with streaming replication and repmgr. > Operating system is RHEL6.8 > > On the master I can see multiple postmaster processes from the same data > directory. > > ps -ef |grep -i postgres|grep postm > postgres 81440 1 0 Jan31 ?

Multiple postmasters running from same directory

2018-02-13 Thread Vikas Sharma
Hi, We are running Postgresql 9.4 with streaming replication and repmgr. Operating system is RHEL6.8 On the master I can see multiple postmaster processes from the same data directory. ps -ef |grep -i postgres|grep postm postgres 81440 1 0 Jan31 ?00:11:37