Linux Today: Linux News On Internet Time.

More on LinuxToday

Server Configuration Tuning in PostgreSQL

Oct 22, 2010, 12:04 (0 Talkback[s])
(Other stories by Gregory Smith)


Desktop-as-a-Service Designed for Any Cloud ? Nutanix Frame

[ Thanks to Naheed for this link. ]


"General logging setup is important but it is somewhat outside the scope of this article. You may need to set parameters such as log_destination, log_directory, and log_filename to save your log files in a way compatible with the system administrations requirements of your environment. These will all be set to reasonable defaults to get started with on most systems.

"On UNIX-like systems, it's common for some of the database logging to be set in the script that starts and stops the server, rather than directly in the postgresql.conf file. If you instead use the pg_ctl command to manually start the server, you may discover that logging ends up on your screen instead. You'll need to look at the script that starts the server normally (commonly /etc/init.d/postgresql) to determine what it does, if you want to duplicate that behavior. In most cases, you just need to add –l logfilename to the pg_ctl command line to redirect its output to the standard location. log_line_prefix

"The default log_line_prefix is empty, which is not what you want. A good starting value here is the following:"

Complete Story

Related Stories: