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 -


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


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


  • sudo apt-get install apache2-utils
  • ab -n 10 - note the timing results
  • sudo apt-get install postgresql postgresql-client
  • sudo -u postgres psql
    • 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 - 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
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