You must configure specific properties in the postgresql.conf file.

1

Under the listen_addresses property, enable database connections on all interfaces on the platform. listen_addresses = '*'

2

Under the max_connections property, set the maximum number of connections based on the sizing profile that corresponds to the scale of your environment. Use the following values.

Value

Description

?

Small

?

Medium

500

Large

3

Under the shared_buffers and effective_cache_size property, assuming the database runs on a dedicated platform, set shared_buffers to 70-80% of memory, and effective_cache_size to 10-20%, leaving some memory available for the operating system.

For example, given 12GB of memory, shared_buffers = 8GB and effective_cache_size = 2GB.

4

Under the checkpoint_segments property, verify that the value on the sizing profile corresponds to the scale of your environment. Use the following values.

Value

Description

checkpoint_segments = 3 (default)

Small

checkpoint_segments = 3 (default)

Medium

checkpoint_segments = 32 (default)

Large

Configure the PostgreSQL client authentication properties. See Configure PostgreSQL Client Authentication.