This article is in process of being moved over from my Google Sites wiki
Install Required Libraries
In order to render thumbnails ect... you need certain x-windows libraries. Refer to the list from the Confluence install instructions and make sure to use the list matching your version of Confluence.
Because the list changes between each release, I recommend documenting what you installed. When upgrading, I recommend uninstalling all the required libs from the previous release and then installing the required libraries with the new release.
Configure PostgreSQL
Setup PostgreSQL6.0 PostgreSQL on Ubuntu.
These are abridged instructions from Confluences wiki on setting up an external database.
Rather than use the gui we can do everything from the command line. I am pulled the command line from the visual guide by Confluence.
First log into the PostgreSQL prompt as explain in PostgreSQL on Ubuntu.
Create the confluence database admin account,
CREATE ROLE confluencedbuser LOGIN ENCRYPTED PASSWORD 'putYourPasswordHere' NOINHERIT VALID UNTIL 'infinity'; COMMENT ON ROLE confluencedbuser IS 'Account used by the Confluence application.';
Create the database. I changed the default name confluence to confluencedb. As a coder it will be easier for me later one.
CREATE DATABASE confluencedb WITH ENCODING='UTF8' OWNER=confluencedbuser CONNECTION LIMIT=-1;
Confluence 3.2 does include a JDBC driver for PostgreSQL. HOWEVER, because we are using the newest Java download the JDBC4 driver from the PostgreSQL website.
First delete the jdbc3 driver,
rm /opt/confluence/confluence/WEB-INF/lib/postgresql-8.4-701.jdbc3.jar
Then, place the JDBC Driver postgresql-8.4-701.jdbc4.jar into the <confluence-install-path>/confluence/WEB-INF/lib folder.