O'Reilly logo

PostgreSQL 9 Administration Cookbook by Hannu Krosing, Simon Riggs

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Which parameters are at non-default settings?

Often, we need to check which parameters have been changed already or whether our changes have correctly taken effect.

How to do it...

 postgres=# SELECT name, source, setting FROM pg_settings WHERE source != 'default AND source != 'override' ORDER by 2, 1; …..........name …..........|........source.......|..setting ---------------------------+---------------------+---------- application_name | client | psql log_timezone | command line | GB TimeZone | command line | GB timezone_abbreviations | command line | Default archive_command | configuration file | (disabled) archive_mode | configuration file | off archive_timeout | configuration file | 5 bgwriter_delay | configuration file | 10 checkpoint_timeout ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required