patternsqlMinor
Postgres 9.6 reload or restart after config changes
Viewed 0 times
afterrestartpostgresreloadconfigchanges
Problem
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?
Is there a list of parameters that need a restart?
Solution
Try this query:
The
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.Code Snippets
SELECT name, context
FROM pg_settings
WHERE name ilike '%log%';Context
StackExchange Database Administrators Q#162848, answer score: 6
Revisions (0)
No revisions yet.