Server Configuration

From PostgreSQL wiki

Revision as of 17:55, 19 January 2013 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, 'version()'::text AS source
UNION ALL
SELECT  name, current_setting(name), source
FROM    pg_settings
WHERE   source NOT IN ('default', 'override');
Personal tools