This page last changed on Nov 24, 2008 by twong.

This guide was created on a Windows XP Service Pack 3 machine. Please check the Known Issues for PostgreSQL before you start.

Installing PostgreSQL, Creating a User, and Creating a Database


  1. Obtain the Postgres One Click Installer for Windows. Save it to your desktop.
  2. Double click on the installer.

Setting up Confluence to use the Postgres DB


At this point, you will need to download a JDBC driver from the Postgres website for use with Confluence You'll need the JDBC3 driver if you're using JDK 1.4 / JDK 1.5 and the JDBC4 driver for JDK 1.6.

If the server that is hosting the PostgreSQL db is not the same server as Confluence, then please ensure that the confluence server can contact the database server and also refer to the PostgreSQL documentation on how to set up pg_hba.conf If the pg_hba.conf file is not set properly, remote communication to the PostgresSQL server will fail.

  1. Place the JDBC Driver into the <confluence-install-path>/confluence/WEB-INF/lib folder.
  2. Start Confluence.

Troubleshooting


If you are unable to connect to the database from Confluence and they are on different machines, most likely you have a firewall in between the two machines or your pg_hba.conf file is misconfigured. Verify that your firewall is set to allow connections through 5432 or double check your hba configuration

If Confluence is complaining that it's missing a class file, you might have forgotten to place the jdbc driver in the WEB-INF/lib folder or possibly have placed it in the wrong folder.

If none of the above describes your issue, please create a support ticket at http://support.atlassian.com and be sure to include your logs (found in confluence-install/logs and confluence-data/logs).


2008-11-24_1512.png (image/png)
2008-11-24_1511.png (image/png)
2008-11-24_1501.png (image/png)
2008-11-24_1502.png (image/png)
2008-11-24_1505.png (image/png)
2008-11-24_1527.png (image/png)
2008-11-24_1522.png (image/png)
2008-11-24_1514.png (image/png)
2008-11-24_1517.png (image/png)
2008-11-24_1520.png (image/png)
2008-11-24_1537.png (image/png)
2008-11-24_1536.png (image/png)
2008-11-24_1531.png (image/png)
2008-11-24_1532.png (image/png)
2008-11-24_1534.png (image/png)
2008-11-24_1557.png (image/png)
2008-11-24_1626.png (image/png)
2008-11-24_1627.png (image/png)
2008-11-24_1628.png (image/png)
2008-11-24_1629.png (image/png)
Document generated by Confluence on Dec 03, 2008 15:13