Postgresql – Postgres 9.6 reload or restart after config changes

postgresqlpostgresql-9.6

I need to change a couple of log config settings in postgresql.conf. How do I know which parameters need a restart or reload?

Is there a list of parameters that need a restart?

Best Answer

Try this query:

SELECT name, context
FROM pg_settings
WHERE name ilike '%log%';

The pg_settings view gives the context for any setting. sighup is a reload and postmaster is a restart.

Related Question