"Tena Sakai" <tsakai@xxxxxxxxxxxxxx> writes: > Can I just uncomment log_line_prefix entry and stick what I want > (such as %u, %d, %m, etc) into the quotes and expect to see the > logged lines be prefixed with username, database name, timestamp, > etc with all other things intact? Sure; you will however regret by and by that you didn't turn on redirect_stderr, because there is no way to rotate the logfile (other than restarting the postmaster) when it's simply going straight to stderr. The more verbose you make the log, the sooner its bulk is going to become a problem... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster