Skip site navigation (1) Skip section navigation (2)

Re: session id and global storage

From: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
To: <hannu(at)skype(dot)net>
Cc: <david(dot)hoksza(at)seznam(dot)cz>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: session id and global storage
Date: 2006-06-01 10:53:05
Message-ID: 2568.24.211.165.134.1149159185.squirrel@www.dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers 
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

In response to

pgsql-hackers by date

Next:From: Robert TreatDate: 2006-06-01 11:46:56
Subject: Re: [PATCH] Magic block for modules
Previous:From: Hannu KrosingDate: 2006-06-01 09:16:37
Subject: Re: session id and global storage

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group