diff options
| author | David Leutgeb <david@noreply.localhost> | 2022-08-18 09:41:52 +0200 |
|---|---|---|
| committer | David Leutgeb <david@noreply.localhost> | 2022-08-18 09:41:52 +0200 |
| commit | 550434f33aa9ffdebe9a4e79f00738b2814cb139 (patch) | |
| tree | 24cf3c26004ec1de5a39ded274ad9230a040f636 /change_settings.md | |
| parent | 3d5dc3cc70a37d24e1c1c8fc6ab3549f28a5e9c0 (diff) | |
| download | postgresql_hacks-550434f33aa9ffdebe9a4e79f00738b2814cb139.tar.gz postgresql_hacks-550434f33aa9ffdebe9a4e79f00738b2814cb139.zip | |
Added commands for configuration check
Diffstat (limited to 'change_settings.md')
| -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 |