Re: pgAdmin v1.10.0 Beta 1

On Thu, Mar 19, 2009 at 9:43 AM, Glyn Astill <glynastill(at)yahoo(dot)co(dot)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