On Mon, Oct 16, 2006 at 10:05:52PM +0100, Jeremy Harris said:
> Tom Kistner wrote:
> > Jeremy Harris wrote:
> >
> >> DBD::Pg::st execute failed: ERROR: parser: parse error at or near
> >> "OPTIMIZE" at character 1 at
> >> /usr/local/exilog/bin/../Exilog/exilog_sql.pm line 201.
> >
> > Funny we just had this issue discussed 3-4 weeks back.
> >
> > See
> >
> > http://www.exim.org/mail-archives/exim-users/Week-of-Mon-20060918/msg00038.html
>
> Ah, thanks. This system's still on a 7-series pg, so can't autovacuum.
> I'll try to hack on that file until it works, on the assumption that
> a vacuum analyze is the thing wanted here, it seem likely for a weekly
> maintenance operation. I'll post diffs once running.
There is an autovacuum for postgres 7 (package postgres-contrib in
debian). I don't know what you're running on, so I can't help more than
that.
--
--------------------------------------------------------------------------
| Stephen Gran | Talking about a piece of movie |
| steve@??? | dialogue: Let's have some new |
| http://www.lobefin.net/~steve | cliches. -Samuel Goldwyn |
--------------------------------------------------------------------------
