Server Configuration

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(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
+
SELECT 'version'::text AS name, version() AS current_setting
  'version'::text as "name",
+
UNION ALL
  version() as "current_setting"
+
SELECT name, current_setting(name)
UNION ALL
+
FROM   pg_settings
  SELECT
+
WHERE   source != 'default' AND
  name,current_setting(name)  
+
        name NOT IN
FROM pg_settings  
+
(
WHERE NOT source='default' AND NOT name IN
+
        'config_file','data_directory','hba_file','ident_file','log_timezone',
  ('config_file','data_directory','hba_file','ident_file',
+
        'DateStyle','lc_messages','lc_monetary','lc_numeric','lc_time',
  'log_timezone','DateStyle','lc_messages','lc_monetary',
+
        'timezone_abbreviations','default_text_search_config','application_name',
  'lc_numeric','lc_time','timezone_abbreviations',
+
        'transaction_deferrable','transaction_isolation','transaction_read_only'
  '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:

Administrative Snippets

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'
);
Personal tools