Added commands for configuration check

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