Re: [GENERAL] Fwd: 2 process postgres -D for one instance
Don Seiler writes: > Yes exactly. That's the parent PID for that process. Presumably, the reason the command columns look the same is that the child process hasn't yet had a chance to change its PS display string. The fact that its accumulated runtime shows as 00:00:00 squares with that. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Fwd: 2 process postgres -D for one instance
Yes exactly. That's the parent PID for that process. On Fri, Aug 11, 2017 at 2:44 PM, Ron Johnson wrote: > On 08/11/2017 02:35 PM, Peter Eisentraut wrote: > > On 8/11/17 10:15, Murtuza Zabuawala wrote: > > some time whe have 2 process postgres for 1 instance like this > > > exppgs *17769* 1 0 01:06 ?00:01:04 > /usr/pgsql-9.3/bin/postgres -D /bases/postgresql/scl/data -i -p 5450 -h > bd-sillage.info. > exppgs 39922 *17769* 0 15:39 ?00:00:00 > /usr/pgsql-9.3/bin/postgres -D /bases/postgresql/scl/data -i -p 5450 -h > bd-sillage.info. > > It appears that the second one is a process forked off from the first > one. That looks normal to me. > > > Because of the reference to 17769 in the second entry? > > -- Don Seiler www.seiler.us
Re: [GENERAL] Fwd: 2 process postgres -D for one instance
On 08/11/2017 02:35 PM, Peter Eisentraut wrote: On 8/11/17 10:15, Murtuza Zabuawala wrote: some time whe have 2 process postgres for 1 instance like this exppgs*17769* 1 0 01:06 ?00:01:04 /usr/pgsql-9.3/bin/postgres -D /bases/postgresql/scl/data -i -p 5450 -h bd-sillage.info. exppgs 39922*17769* 0 15:39 ?00:00:00 /usr/pgsql-9.3/bin/postgres -D /bases/postgresql/scl/data -i -p 5450 -h bd-sillage.info. It appears that the second one is a process forked off from the first one. That looks normal to me. Because of the reference to 17769 in the second entry?
Re: [GENERAL] Fwd: 2 process postgres -D for one instance
On 8/11/17 10:15, Murtuza Zabuawala wrote: > some time whe have 2 process postgres for 1 instance like this > > > exppgs 17769 1 0 01:06 ?00:01:04 > /usr/pgsql-9.3/bin/postgres -D /bases/postgresql/scl/data -i -p 5450 -h > bd-sillage.info. > exppgs 39922 17769 0 15:39 ?00:00:00 > /usr/pgsql-9.3/bin/postgres -D /bases/postgresql/scl/data -i -p 5450 -h > bd-sillage.info. It appears that the second one is a process forked off from the first one. That looks normal to me. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general