Server Configuration

From PostgreSQL wiki

Revision as of 15:58, 16 February 2011 by Kgrittn (Talk | contribs)

Jump to: navigation, search

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 NOT source='default' AND NOT name 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