Server Configuration
From PostgreSQL wiki
(Difference between revisions)
(Exclude some settings which show in 9.1 which aren't useful, add in version and settings which are often needed.) |
(Update query layout) |
||
| Line 2: | Line 2: | ||
{{SnippetInfo|Dependency display|lang=SQL|category=Administrative}} | {{SnippetInfo|Dependency display|lang=SQL|category=Administrative}} | ||
<source lang="sql"> | <source lang="sql"> | ||
| - | + | SELECT 'version'::text AS name, version() AS current_setting | |
| - | + | UNION ALL | |
| - | + | SELECT name, current_setting(name) | |
| - | + | FROM pg_settings | |
| - | + | WHERE source != 'default' AND | |
| - | + | name NOT IN | |
| - | + | ( | |
| - | + | 'config_file','data_directory','hba_file','ident_file','log_timezone', | |
| - | + | 'DateStyle','lc_messages','lc_monetary','lc_numeric','lc_time', | |
| - | + | 'timezone_abbreviations','default_text_search_config','application_name', | |
| - | + | 'transaction_deferrable','transaction_isolation','transaction_read_only' | |
| - | + | ); | |
| - | + | ||
| - | + | ||
</source> | </source> | ||
[[Category:SQL]] | [[Category:SQL]] | ||
Revision as of 16:43, 19 January 2013
This shows all of the server configuration changes made via updates to the postgresql.conf file, from a running server:
Dependency display
Works with PostgreSQL
Any version
Written in
SQL
Depends on
Nothing
SELECT 'version'::text AS name, version() AS current_setting UNION ALL SELECT name, current_setting(name) FROM pg_settings WHERE source != 'default' AND name NOT IN ( 'config_file','data_directory','hba_file','ident_file','log_timezone', 'DateStyle','lc_messages','lc_monetary','lc_numeric','lc_time', 'timezone_abbreviations','default_text_search_config','application_name', 'transaction_deferrable','transaction_isolation','transaction_read_only' );
