On Friday August 27 2004 1:39, Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Ah, so we keep the existing format but drop the pid, and just make it > > changable by the user, and we rename it. Doesn't sound as drastic as > > it first did. > > Yeah, the only change in default behavior would be to drop the PID part > of the log filename, which doesn't seem too bad, since people aren't yet > depending on that. > > regards, tom lane
OK, if I read you correctly... Default remains "postgresql-%Y-%m-%d_%H%M%S.log" (Apache style: access_log.%s) If log_filename = 'xxx', rotate with strftime() to 'xxx-%Y-%m-%d_%H%M%S' (Apache style: xxx.%s) If log_filename = 'xxx.%a', rotate with strftime() to 'xxx.%a' (Apache style: xxx.%a) Not a big fan of the verbose 32-character default name, 'server_log.%s' would be my pick, but easy enough to override it. Ed ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match