Confluence Docs 3.1 : Database Setup for PostgreSQL on Windows
This page last changed on Sep 06, 2009 by ggaskell.
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
Setting up Confluence to use the PostgreSQL DatabaseAt this point, you will need to download a JDBC driver from the PostgreSQL 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.
Running SQL QueriesFor ongoing maintenance of your server, you can continue to use PGAdmin as your SQL browser. TroubleshootingIf 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). ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
Document generated by Confluence on Dec 10, 2009 18:45 |