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');
Retrieved from "http://wiki.postgresql.org/wiki/Server_Configuration"
Personal tools