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