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 PostgreSQL pg_hba.conf file documentation.