HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Postgres 9.6 reload or restart after config changes

Submitted by: @import:stackexchange-dba··
0
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?

Solution

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.

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.