Postgres Pro
Downloads
Home   >   mailing lists

Re: session id and global storage - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: session id and global storage
Date
Msg-id 2568.24.211.165.134.1149159185.squirrel@www.dunslane.net
Whole thread Raw
In response to Re: session id and global storage  (Hannu Krosing <hannu@skype.net>)
List pgsql-hackers
Tree view 
Hannu Krosing said:
> Ühel kenal päeval, N, 2006-06-01 kell 10:10, kirjutas David Hoksza:
>> It seems MyProcID is what I was searching for...
>>
>
> On a buzy server with lots of connects, procID will repeat quite often.
>

log_line-prefix has a sessionid gadget:

Session ID: A unique identifier for each session. It is 2 4-byte hexadecimal
numbers (without leading zeros) separated by a dot. The numbers are the
session start time and the process ID

Assuming PIDs are not reused within one second that will be unique.

cheers

andrew

pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: session id and global storage
Next
From: "Mark Woodward"
Date:
Subject: Re: Possible TODO item: copy to/from pipe