Configure PostgreSQL to allow remote connections - Perceptive Content Database Install Guide - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

Perceptive Content Database Install Guide

Platform
Perceptive Content
Product
Perceptive Content Database Install Guide
Release
Foundation 24.1
License

To configure PostgreSQL to allow remote connections, complete the following steps.

  1. In the ph_hba.conf file, add a line for each server that will connect to the INOW database.
    Note: To restrict the establishment of connections, we recommend using a specific IP address. Although not recommended for security reasons, you have the ability to use "all" to allow connections from all servers.

    The addressspecifiesthe set of hoststhat matchesthe records. It can be a host name or a combination of an IPaddress and CIDR mask that contains an integer between 0 and 32, for IPv4; or between 0 and 128, for IPv6 that specifies the number of the significant bits in the mask.

  2. After making updates, restart the PostgreSQL service "pg_ctl restart" or call "pg_ctl reload".

    This signals a SIGHUP to the postmaster and initializes the changes.

    Note: You must restart thePostgreSQL service; otherwise, thePerceptive ContentServer will not be able to connect to the INOW database.