HOWTO: Configure PageCache with PostgreSQL on Debian/Ubuntu with Foswiki 1.2+

  • Tip Category - Installation and Upgrading
  • Tip Added By - PaulHarvey - 16 Mar 2012 - 00:04
  • Extensions Used -
  • Useful To - Beginners
  • Tip Status - New
  • Related Topics -

Problem

You want to enable the PageCaching feature on your installation using Postgres to store cache objects

Context

ALERT! This document applies to Foswiki 1.2+, which has not yet been released.

Your Foswiki installation is otherwise fully configured and working, and running on Debian or one of its descendants

Solution

  • sudo apt-get install apache2-utils
  • ab -n 10 http://your.org/foswiki/Main/WebHome - note the timing results
  • sudo apt-get install postgresql postgresql-client
  • sudo -u postgres psql
    • CREATE USER fwcacheuser WITH ENCRYPTED PASSWORD 'foo';
    • CREATE DATABASE foswiki OWNER fwcacheuser;
  • Visit Foswiki's /bin/configure page, go to Tuning -> Cache
  • Check {Cache}{Enabled}
  • On {Cache}{Implementation}, choose Foswiki::PageCache::DBI::PostgreSQL
  • In {Cache}{DBI}{PostgreSQL}{Port}, set 5432
  • In {Cache}{DBI}{PostgreSQL}{Database}, set foswiki
  • In {Cache}{DBI}{PostgreSQL}{Username}, set fwcacheuser
  • In {Cache}{DBI}{PostgreSQL}{Password}, set foo
  • ab -n 10 http://your.org/foswiki/Main/WebHome - note the timing results; you should see an improvement similar to the numbers documented at Tasks.Item11549

Known Uses

Known Limitations

See Also

BestPracticeTipsForm edit

Category Installation and Upgrading
Related Topics
Topic revision: r1 - 16 Mar 2012, PaulHarvey - This page was cached on 18 Oct 2018 - 02:25.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy