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

What are the current configuration settings?

At some point it will occur to you to ask, "What are the current configuration settings?"

How to do it...

Your first thought is probably "look in postgresql.conf". That works, but only as long as there is only one parameter file. If there are two, then maybe you're reading the wrong file! (How do you know?). So the cautious and accurate way is not to trust a text file, but to trust the server itself.

Also, we learned in the recipe When to set parameters that each parameter has a scope that determines when it can be set. Some parameters can be set through postgresql.conf, but others can be changed afterwards also. So the current value of configuration settings may have been subsequently changed.

We can ...

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