PostgreSQL non default settings
Non default configuration directives and values defined in pg_settings.
| Client Connection Defaults / Locale and Formatting | ||||
|---|---|---|---|---|
| Name | Current | Unit | Reset val | Boot val |
| DateStyle | ISO. DMY | 0 | ISO. DMY | ISO. MDY |
| default_text_search_config | pg_catalog.french | 0 | pg_catalog.french | pg_catalog.simple |
| lc_messages | fr_FR.UTF-8 | 0 | fr_FR.UTF-8 | "" |
| lc_monetary | fr_FR.UTF-8 | 0 | fr_FR.UTF-8 | C |
| lc_numeric | fr_FR.UTF-8 | 0 | fr_FR.UTF-8 | C |
| lc_time | fr_FR.UTF-8 | 0 | fr_FR.UTF-8 | C |
| TimeZone | Europe/Paris | 0 | Europe/Paris | GMT |
| Client Connection Defaults / Shared Library Preloading | ||||
| Name | Current | Unit | Reset val | Boot val |
| shared_preload_libraries | credcheck | 0 | credcheck | "" |
| Client Connection Defaults / Statement Behavior | ||||
| Name | Current | Unit | Reset val | Boot val |
| lock_timeout | 3000 | ms | 3000 | |
| search_path | "" | 0 | """$user"". public" | """$user"". public" |
| Customized Options | ||||
| Name | Current | Unit | Reset val | Boot val |
| credcheck.max_auth_failure | 2 | 0 | 2 | |
| credcheck.password_reuse_history | 3 | 0 | 3 | |
| credcheck.password_valid_max | 91 | 0 | 91 | |
| credcheck.password_valid_until | 41 | 0 | 41 | |
| Reporting and Logging / What to Log | ||||
| Name | Current | Unit | Reset val | Boot val |
| application_name | pgcluu | 0 | psql | "" |
| log_timezone | Europe/Paris | 0 | Europe/Paris | GMT |