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 | | [EMAIL PROTECTED] | dialogue: Let's have some new | | http://www.lobefin.net/~steve | cliches. -Samuel Goldwyn | -------------------------------------------------------------------------- -- ## List details at http://www.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://www.exim.org/eximwiki/
