Installing PostgreSQL

Prior to installing PostgreSQL, complete the installation requirements (see Requirements for your Database Software).

Step 1. Installing PostgreSQL on Windows

To install and configure PostgreSQL on a Windows system, complete the following steps:

1. Double-click the PostgreSQL .exe file to launch the PostgreSQL installer.
2. In the Welcome page, click Next.
3. In the Installation Directory page, select the directory and click Next.
4. In the Data Directory page, select the directory and click Next.
5. Enter a password for the database superuser (default = postgres), and click Next.
6. Select the port number (default = 5432) and click Next.
7. In the Advanced Options page, select the locale to be used and click Next.
8. Click Next.
9. In the last wizard page, de-select the Stack Builder option and click Finish.

Note 

By default, PostgreSQL is installed on localhost (127.0.0.1), and postgres is assigned as both the username and password of the default user account.

Step 2. Creating a User Role

If you want to create a custom PostgreSQL user role for use with TLC, complete the following steps:

1. From Windows Start menu, select All Programs > PostgreSQL > pgAdmin.
2. In the Object browser, double-click your PostgreSQL server and enter the password for the postgres superuser.
3. Right-click Login Roles and select New Login Role.
4. In the New Login Role window, enter a name for the new Role in the Properties tab.
5. In the Definition tab, enter the password for the new Role.
6. As appropriate, complete the other tabs for the Role and click OK.

Step 3. Configuring PostgreSQL for Remote Access

If you plan to install one or more Secondary Managers that will require access to PostgreSQL, complete the following steps:

1. Open the following file: 

<postgresql_install_path>\<version>\data\pg_hba.conf

Where <version> is the version number for PostgreSQL (e.g., 9.5 or 9.6).

2. In the "TYPE DATABASE USER ADDRESS METHOD" section at the bottom of the file, enter the IP address of each Manager host that will connect to PostgreSQL. For example: 

# TYPE DATABASE USER ADDRESS METHOD

IPv4 local connections: host all all 10.0.0.1/32 password

To permit all IP addresses to connect to the database server:

# TYPE DATABASE USER ADDRESS METHOD

IPv4 local connections: host all all 0.0.0.0/0 password

3. Save and close the pg_hba.conf file, and open the following file:

<postgresql_install_path>\<version>\data\postgresql.conf

4. In the "CONNECTIONS AND AUTHENTICATION" section, edit the listen_addresses value to permit PostgreSQL to listen on all IP addresses:

listen_addresses = '*'