Fwd: 2 process postgres -D for one instance
Forwarding to pgsql-general list.
---------- Forwarded message ----------
From: francis cherat <renaultf11@hotmail.com>
Date: Fri, Aug 11, 2017 at 7:36 PM
Subject: 2 process postgres -D for one instance
To: "pgadmin-support@lists.postgresql.org" <
pgadmin-support@lists.postgresql.org>
Hi,
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.xxxx
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.xxxx
is it an expected behavior ?
Regards
Francis
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.xxxx
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.xxxx
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
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.xxxx
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.xxxxIt 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?
Import Notes
Reply to msg id not found: vve21v03r1DF5NZ01ve4x8
Yes exactly. That's the parent PID for that process.
On Fri, Aug 11, 2017 at 2:44 PM, Ron Johnson <ron.l.johnson@cox.net> 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.xxxx
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.xxxxIt 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
Don Seiler <don@seiler.us> 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