Server Configuration

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(Update query layout)
(Add source and use NOT IN ('default', 'override') instead of explicit list of excluded settings, per recommendation of Tom Lane.)
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
+
SELECT  'version'::text AS name, version() AS current_setting, 'version()'::text as source
 
UNION ALL
 
UNION ALL
SELECT  name, current_setting(name)
+
SELECT  name, current_setting(name), source
 
FROM    pg_settings
 
FROM    pg_settings
WHERE  source != 'default' AND
+
WHERE  source NOT IN ('default', 'override');
        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 17:55, 19 January 2013

This shows all of the server configuration changes made via updates to the postgresql.conf file, from a running server:

Administrative Snippets

Dependency display

Works with PostgreSQL

Any version

Written in

SQL

Depends on

Nothing

SELECT  'version'::text AS name, version() AS current_setting, 'version()'::text AS source
UNION ALL
SELECT  name, current_setting(name), source
FROM    pg_settings
WHERE   source NOT IN ('default', 'override');
Personal tools