Re: vacuumdb error

2009/10/16 Thom Brown <thombrown(at)gmail(dot)com>:
> Hi,
>
> I've noticed I can't run vacuumdb with ALL FULL VERBOSE and FREEZE.
>
> The error returned is:
>
> vacuumdb: vacuuming of database "killingcupid.co.uk" failed: ERROR:
> syntax error at or near "FREEZE"
> LINE 1: VACUUM FULL VERBOSE FREEZE;
>
> The commands I used are:
>
> vacuumdb -afFv
> vacuumdb --all --full --freeze --verbose
>
> I've tried moving the switches round to put them in the order
> specified in the documentation, just in case it had any effect on the
> order of the keywords, but it doesn't.  I can run this manually in
> psql using:
>
> VACUUM FULL FREEZE VERBOSE;
>
> This is either a bug in vacuumdb with it not using the correct order,
> or postgres shouldn't be paying attention to the order of the
> keywords.  In any case, it doesn't work.  I've searched the postgres
> FAQs, TODO and mailing list archives, but can't find a mention of
> this.
>
> Thanks
>
> Thom
>

I should also mention this is using PostgreSQL 8.4.1 and vacuumdb is
dated 2009-09-03. The error also still occurs if I remove FULL from
the command.

Thom