Install and Configure PostgreSQL
To install PostgreSQL, go to http://www.postgresql.org/download/ and follow the instructions to download and install the software in the appropriate format for your system.
After you have installed PostgreSQL, you must carry out the following configuration changes.
-
Create a PostgreSQL user for IDOL Site Admin to use when it connects to the database. For more information on how to create a new PostgreSQL user account, refer to the PostgreSQL
createuser
documentation.NOTE: You must also create an associated database for that user.
- In the
pg_hba.conf
file, configure PostgreSQL to accept connections from the IDOL Site Admin host. For more information about client authentication, refer to the PostgreSQLpg_hba.conf
file documentation.