Re: [GENERAL] Fwd: 2 process postgres -D for one instance

2017-08-11 Thread Tom Lane 
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

2017-08-11 Thread Don Seiler 
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

2017-08-11 Thread Ron Johnson 

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

2017-08-11 Thread Peter Eisentraut 
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

[GENERAL] Fwd: 2 process postgres -D for one instance

2017-08-11 Thread Murtuza Zabuawala 
Forwarding to pgsql-general list.


-- Forwarded message --
From: francis cherat 
Date: Fri, Aug 11, 2017 at 7:36 PM
Subject: 2 process postgres -D for one instance
To: "pgadmin-supp...@lists.postgresql.org" <
pgadmin-supp...@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.
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.


is it  an expected behavior ?


Regards

Francis