Server Configuration

From PostgreSQL wiki
Jump to navigationJump to 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();
SELECT name, current_setting(name), source
  FROM pg_settings
  WHERE source NOT IN ('default', 'override');