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. |
|
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 = '*'