Bug#969311: UDD: please install pg_stat_statements extension

[Michael Banck <mbanck@debian.org>]

owner 969311 mbanck@debian.org
thanks

On Mon, Aug 31, 2020 at 10:02:52AM +0200, Michael Banck wrote:
> In order to best assess where and how to improve the situation, please
> install the pg_stat_statements extension in the udd database, like
> 
> CREATE EXTENSION pg_stat_statements;

Gah, I forgot that pg_stat_statements requires a preloaded library. So
before the above can work, postgresql.conf needs to be changed:

-#shared_preload_libraries = ''          # (change requires restart)
+shared_preload_libraries = 'pg_stat_statements' # (change requires restart)

As indicated, this will only take effect after the next server restart,
then the extension can be created.

pg_stat_statements is part of the core set of Postgres extensions and
does not need to be installed via packages.


Michael