Re: pgAdmin v1.10.0 Beta 1

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