Configure connection settings - 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

Update hba_file.conf

psql -U postgres -d postgres -c "show hba_file"

Add "all" to allow all, otherwise for access that is more restrictive specify a specific database, user and IP address for all connections to the database. For the address field append /32 for IPv4 addresses and /128 for IPv6 addresses.

# TYPE                    DATABASE 	USER 	ADDRESS 			    METHOD
# IPv4 local connections:
host 			 	INOW          inuser    <<inserver ipaddress>>/32  md5
host 				 all           all       127.0.0.1/32               md5

Update postgresql.conf

To update postgresql.conf, modify the listener_addresses and max_connections parameters.

Note: Changes to this file require a PostgreSQL Server restart.
#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------
# - Connection Settings -
listen_addresses = '*'                   # what IP address(es) to listen on;
                                         # comma-separated list of addresses;
                                         # defaults to 'localhost'; use '*' for all
                                         # (change requires restart)
port = 5432                              # (change requires restart)
max_connections = 300                    # (change requires restart)