PostgreSQL - Notes
13 Apr 2019session vs. connection
https://stackoverflow.com/a/46323144/3632318
a session is “synonymous with a TCP connection”
custom configuration
add custom configuration in postgresql.conf and pg_hba.conf files:
https://www.endpoint.com/blog/2010/09/27/postgres-configuration-best-practices
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:
https://www.postgresql.org/docs/current/config-setting.html
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.