Search Postgresql Archives

Re: Unique Session ID in PGSQL?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello

2011/5/18 Durumdara <durumdara@xxxxxxxxx>:
> Hi!
>
> Is there any function in PGSQL that returns an unique Session
> identifier of the actual session?
> For example a Bigint, or GUID, or etc?
> Can I get the living Session identifiers from PG?

try

postgres=# select pg_backend_pid();
 pg_backend_pid
----------------
          17327
(1 row)

postgres=# \x
Expanded display is on.
postgres=# select * from pg_stat_activity where procpid = pg_backend_pid();
-[ RECORD 1 ]----+-----------------------------------------------------------------
datid            | 12835
datname          | postgres
procpid          | 17327
usesysid         | 16384
usename          | pavel
application_name | psql
client_addr      |
client_hostname  |
client_port      | -1
backend_start    | 2011-05-18 14:46:08.099399+02
xact_start       | 2011-05-18 15:08:21.5958+02
query_start      | 2011-05-18 15:08:21.5958+02
waiting          | f
current_query    | select * from pg_stat_activity where procpid =
pg_backend_pid();

Regards

Pavel Stehule
>
> We have a little application that uses these infos which are basically
> came from another database system, and I will port this, but I don't
> know, how to do in PGSQL...
> In this app. we associated (stored) the session id to a special field
> in some tables.
> We can retreive the living session ids with a system functions.
>
> If a session died, these records have become irrelevant - we can
> delete them. If the session still alive, we don't touch them, only can
> read the content...
>
> I see adv_locks in pg, but because the quantity of locks are
> pre-determined by the server, I don't choose them.
> I better like a technic that cannot exhaust the number of persistent elements.
>
> Thanks:
> Â dd
>
> --
> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux