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 |
| default_text_search_config | pg_catalog.english | 0 | pg_catalog.english | pg_catalog.simple |
| lc_messages | en_US.utf-8 | 0 | en_US.utf-8 | "" |
| lc_monetary | en_US.utf-8 | 0 | en_US.utf-8 | C |
| lc_numeric | en_US.utf-8 | 0 | en_US.utf-8 | C |
| lc_time | en_US.utf-8 | 0 | en_US.utf-8 | C |
| TimeZone | America/Mexico_City | 0 | America/Mexico_City | GMT |
| Client Connection Defaults / Statement Behavior | ||||
| Name | Current | Unit | Reset val | Boot val |
| lock_timeout | 3000 | ms | 3000 | |
| search_path | "" | 0 | """$user"". public" | """$user"". public" |
| Connections and Authentication / Security and Authentication | ||||
| Name | Current | Unit | Reset val | Boot val |
| ssl | on | 0 | on | off |
| ssl_cert_file | /etc/ssl/certs/ssl-cert-snakeoil.pem | 0 | /etc/ssl/certs/ssl-cert-snakeoil.pem | server.crt |
| ssl_key_file | /etc/ssl/private/ssl-cert-snakeoil.key | 0 | /etc/ssl/private/ssl-cert-snakeoil.key | server.key |
| Reporting and Logging / What to Log | ||||
| Name | Current | Unit | Reset val | Boot val |
| application_name | pgcluu | 0 | psql | "" |
| log_line_prefix | %t [%p-%l] %q%u@%d | 0 | %t [%p-%l] %q%u@%d | "" |
| log_timezone | America/Mexico_City | 0 | America/Mexico_City | GMT |
| Resource Usage / Memory | ||||
| Name | Current | Unit | Reset val | Boot val |
| max_stack_depth | 2048 | kB | 2048 | 100 |
| shared_buffers | 16384 | 8kB | 16384 | 1024 |
| Statistics / Query and Index Statistics Collector | ||||
| Name | Current | Unit | Reset val | Boot val |
| stats_temp_directory | /var/run/postgresql/9.5-main.pg_stat_tmp | 0 | /var/run/postgresql/9.5-main.pg_stat_tmp | pg_stat_tmp |