Just like Ubuntu and Redgate, CentOS is a Linux distribution and is used by many organizations. Within the Confluence installation process, the question of which database to connect to (in Production) should be “PostgreSQL” and then set the “By Connection String” field to the following.In this article, we are going to learn how we can install PostgreSQL on CentOS. You can point Confluence at this new PostgreSQL database and expect it to work. #psqlĪnd then execute this command to grant all permissions: GRANT ALL PRIVILEGES ON DATABASE confluencedb to confluence Īt this point we’re done. Grant permissions to your new user to the database. When asked to specify a username, specify “confluence”. This command is executed from Bash as the “postgresql” user. The following will allow you to interactively create a new user. createdb confluencedb -encoding='utf-8' -locale=en_US.utf8 -template=template0Īnd create a new user called “confluence”.

Switch to the appropriate user and log in: sudo -i -u postgresĬreate the new database with the “utf-8” encoding as is required by Confluence. Now we create the database ready for Confluence. Now enable and start the PostgreSQL server: systemctl enable postgresql With this (not very secure but is a quick start): host all all 127.0.0.1/32 trust Replace this: host all all 127.0.0.1/32 ident Now set the permissions for the database server: vi /var/lib/pgsql/data/pg_hba.conf

Next you’ll need to do the automatic setup: postgresql-setup initdb yum install postgresql-server postgresql-contrib

Read the other Confluence articles on this blog to ensure your web server (if you’re using one) is configured correctly. This article explains how to install and configure PostgreSQL for a Confluence on a CentOS 7 server.

Postgresql centos 7 install