Advisor check: Settings changed on a instance that requires a restart¶
Description¶
One or more parameter setting requires a server restart/reload following a recent change.
Resolution¶
Use the query below to check the parameters:
SELECT name, setting, short_desc, reset_val FROM pg_settings WHERE pending_restart IS true;
Restart the PostgreSQL server to apply the new value.
Need more support from Percona?¶
Subscribe to Percona Platform to get database support with guaranteed SLAs or proactive database management services from the Percona team.