On Thu, Mar 19, 2009 at 9:43 AM, Glyn Astill <glynastill@yahoo.co.uk> wrote:
>
> I've been playing with this again this morning and I've noticed the "server status" panel is now much nicer.
>
> However one thing that has always tripped me up is that it expects the log_filename to be of the format
"postgresql-%Y-%m-%d_%H%M%S.log",but I've always logged into one file for each day, i.e. "postgresql-%Y-%m-%d.log"
>
> Is there a setting for this somewhere? Else could we get one, or perhaps even read it from the postgresql.conf
settings?
This is a limitation in the server. The pg_logdir_ls function needs
the default logfile format to ensure it can reliably figure out the
log date:
if (strcmp(Log_filename, "postgresql-%Y-%m-%d_%H%M%S.log") != 0) ereport(ERROR,
(errcode(ERRCODE_INVALID_PARAMETER_VALUE), (errmsg("the log_filename
parameter
must equal 'postgresql-%%Y-%%m-%%d_%%H%%M%%S.log'"))));
You can still use per-day logs with the default filename of course -
you'll just need to ignore the time part.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com