This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a simple SHOW ALL command which we can use for getting the list of the defined configuration of PostgreSQL Server.
It shows the settings from the postgresql.conf file which is important for all kind of troubleshooting.
Using SHOW ALL command, you can also search particular setting by name also. For the troubleshooting, we should use this command which is safe than opening a postgresql.conf file for troubleshooting.
Check the particular setting:
|
1 2 3 4 5 |
show shared_buffers; shared_buffers ----------------- 128MB |
Check all settings:
|
1 |
show all; |
Leave a Reply