1Apache::Session::BrowseUasbelre:C:oPngtHrsitbourtee(d3A)PpearclheD:o:cSuemsesnitoant:i:oBnrowseable::PgHstore(3)
2
3
4

NAME

6       Apache::Session::Browseable::PgHstore - Hstore type support for
7       Apache::Session::Browseable::Postgres
8

SYNOPSIS

10       Enable "hstore" extension in PostgreSQL database
11
12         CREATE EXTENSION hstore;
13
14       Create table:
15
16         CREATE UNLOGGED TABLE sessions (
17             id varchar(64) not null primary key,
18             a_session hstore,
19         );
20
21       Optionally, add indexes on some fields. Example for Lemonldap::NG:
22
23         CREATE INDEX uid1 ON sessions USING BTREE ( (a_session -> '_whatToTrace') );
24         CREATE INDEX  s1  ON sessions ( (a_session -> '_session_kind') );
25         CREATE INDEX  u1  ON sessions ( ( cast(a_session -> '_utime' AS bigint) ) );
26         CREATE INDEX ip1  ON sessions USING BTREE ( (a_session -> 'ipAddr') );
27
28       Use it like Apache::Session::Browseable::Postgres except that you don't
29       need to declare indexes
30

DESCRIPTION

32       Apache::Session::Browseable provides some class methods to manipulate
33       all sessions and add the capability to index some fields to make
34       research faster.
35
36       Apache::Session::Browseable::PgHstore implements it for PosqtgreSQL
37       databases using "hstore" extension to be able to browse sessions.
38

SEE ALSO

40       <http://lemonldap-ng.org>, Apache::Session::Postgres
41

AUTHOR

43       Xavier Guimard, <x.guimard@free.fr>
44

46       Copyright (C) 2009-2017 by Xavier Guimard
47                     2013-2017 by Clement Oudot
48
49       This library is free software; you can redistribute it and/or modify it
50       under the same terms as Perl itself, either Perl version 5.10.1 or, at
51       your option, any later version of Perl 5 you may have available.
52
53
54
55perl v5.28.0                      2018-A0p7a-c1h4e::Session::Browseable::PgHstore(3)
Impressum