diff options
| -rw-r--r-- | change_settings.md | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/change_settings.md b/change_settings.md index 55a9dac..aa115b7 100644 --- a/change_settings.md +++ b/change_settings.md @@ -19,3 +19,15 @@ select pending_restart from pg_settings where name='max_wal_size'; ``` This will tell you if a restart is pending for a setting. + +## How to check configuration (postgresql.conf) for configuration errors + +``` +select sourcefile, name,sourceline,error from pg_file_settings where error is not null; +``` + +## How to check pg_hba.conf for configuration errors + +``` +select pg_hba_file_rules(); +```
\ No newline at end of file |