Page History

...

For example, we had one situation where the particular version of the PostgreSQL JDBC driver had a memory leak that would crash Confluence. This was resolved by downloading the most recent JDBC4 Determine your version of PostgreSQL by logging into the server running the database and executing,

psql --version # this will return the version
psql (PostgreSQL) 9.3.9

Downloading the matching JDBC driver from the PostgreSQL website and replacing the .  Review the chart showing version of Java with Postgres. Replacing the old jar the /opt/confluence/confluence/WEB-INF/lib/ directory,

su - serveradmin
cd /opt/confluence/confluence/WEB-INF/lib/
wget http://jdbc.postgresql.org/download/postgresql 
# delete the existing jar
ls postgres*
postgresql-9.12-9011002.jdbc4.jar
rm postgresql-9.02-8011002.jdbc4.jar # Delete the old jar file
 
# In this case the version of Java and Postgres calls for using a newer jdbc41 driver,
wget https://jdbc.postgresql.org/download/postgresql-9.3-1103.jdbc41.jar

Starting the Confluence Service

...