PostgreSQL - Notes

session vs. connection

a session is “synonymous with a TCP connection”

custom configuration

add custom configuration in postgresql.conf and pg_hba.conf files:

Put all important variables at the bottom, sans comments, one per line

If the same setting is listed multiple times, the last one wins.

or else it’s possible to include custom configuration from a separate file but this works for postgresql.conf only:

PostgreSQL provides several features for breaking down complex postgresql.conf files into sub-files.

postgresql.conf file can contain include directives, which specify another file to read and process as if it were inserted into the configuration file at this point.