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

Problem

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

Context

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