Re: connection file descriptors created with identical number after process fork on mac - Mailing list pgsql-general

From John R Pierce
Subject Re: connection file descriptors created with identical number after process fork on mac
Date
Msg-id 325a5bf2-27e7-a787-167a-32379c8cc6e8@hogranch.com
Whole thread Raw
In response to Re: connection file descriptors created with identical number after process fork on mac  (Chris Withers <chris@simplistix.co.uk>)
List pgsql-general
On 8/3/2016 4:25 PM, Chris Withers wrote:
>
> How can I convince myself, from the client side, that I really have
> got a new connection and not somehow ended up with one that been
> passed on as part of the fork?

$ psql -tc "select pg_backend_pid();"
           18635

$ psql -tc "select pg_backend_pid();"
           18665

$ psql -tc "select pg_backend_pid();"
           18727


now, operating system process ID's do get recycled eventually but not
very fast.

--
john r pierce, recycling bits in santa cruz



pgsql-general by date:

Previous
From: Chris Withers
Date:
Subject: Re: connection file descriptors created with identical number after process fork on mac
Next
From: Andy Colson
Date:
Subject: pglogical cross subscribe