This is the hostname or IP address of your database server. By connection string - use this option if you want to specify additional parameters and are comfortable constructing a database URL.ĭepending on the setup type, you'll be prompted for the following information.Simple - this is the most straightforward way to connect to your database.

The Confluence setup wizard will provide you with two setup options: JDBC is the recommended method for connecting to your database. The Confluence setup wizard will guide you through the process of connecting Confluence to your database. Install ConfluenceĬheck out the Confluence Installation Guide for step-by-step instructions on how to install Confluence on your operating system. You can use pgAdmin as an alternative to the command line to complete this step. In Linux systems, if the locale is not utf8, include LC_CTYPE as utf8 during database creation. If you are running PostgreSQL on Windows use the equivalent character type and collation for your locale, for example English_United States.1252 Other collations, such as 'C', are known to cause issues with Confluence. Character encoding must be set to utf8 encoding.Owner is your new database user (for example confluenceuser).Next, create a database (for example confluence):.Your new user must be able to create database objects and must have can login permission.Create a database user, for example confluenceuser.Don't launch Stack Builder at the completion of the installer.Choose the locale that best matches your geographic location.If you decide to change the default port, make sure it does not conflict with any other services running on that port. The default port for PostgreSQL is 5432.Remember this username and password as you'll need it each time you log in to the database. The password you provide during the installation process is for the 'postgres' account, which is the database root-level account (the super user).If you don't already have PostgreSQL installed, download and install it now.

Centos install postgresql