Tim's Blog

Information, Technology, Security, and other stuff.

Confluence and Postgres on CentOS 7

Published 2015-10-05

I've been looking at replacing my DokuWiki instance with Confluence, as I was pleased with the editor and figure it'll be easier for the non-technical users to create pages. It also doesn't hurt to get familiar with the inner workings of a popular product.

It's thankfully a very easy installation over the CLI:

# Update and Install Postgres
yum update -y && yum install postgresql postgresql-server postgresql-jdbc -y

# Enable the Service
systemctl enable postgresql.service

# Create the Initial Cluster
postgresql-setup initdb

# Start the Service
systemctl start postgresql.service

# Trust local traffic to the DB
cat >/var/lib/pgsql/data/pg_hba.conf <<-EOF
local   all    all                     trust
host    all    all    127.0.0.1/32     trust
host    all    all    ::1/128          trust
EOF

# Restart the service for the changes to take effect
systemctl restart postgresql.service

# Create the confluence user and database
sudo -i -u postgres
psql
create role confluenceuser with login password 'N0t4u2c' valid until 'infinity';
create database confluence with encoding='utf-8' owner=confluenceuser connection limit=-1;
\q
exit

# Download and run the installer for Confluence
wget https://www.atlassian.com/software/confluence/downloads/binary/atlassian-confluence-5.8.10-x64.bin
chmod a+x atlassian-confluence-5.8.10-x64.bin
./atlassian-confluence-5.8.10-x64.bin

The confluence installer is really easy to use if everything is already in place. If you run with the default parameters you can just hit the Enter key a whole bunch of times, and then do the rest from the GUI.