Postgres and earthdistance extension

First of all, let me describe how one can install extensions for your Postgresql. It depends whether you have version 8.4+ or 9.1+ installed. In following sections I will describe procedure related to Debian based OSes. First of all, you have to install contrib packages for corresponding version: root@debian:/home/web# apt-cache search postgres | grep contrib postgresql-contrib - additional facilities for PostgreSQL (supported version) postgresql-contrib-8.4 - additional facilities for PostgreSQL postgresql-contrib-9.1 - additional facilities for PostgreSQL with command: ...

September 24, 2013 · 2 min · rodush

How to change PHPMyAdmin session timeout

By default, the session lifetime in a new PhpMyAdmin installation using the “cookie”; authentication method is 1440 seconds (24 minutes). That is, after 24 minutes of inactivity, the next request will take the user to the login page. To increase the session lifetime, set the value of the variable to say, 60x longer: $cfg['LoginCookieValidity'] = 1440 * 60; // 86400 means one day (24-hours)

March 27, 2011 · 1 min · rodush