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

About this task

Procedure

  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

What to do next

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