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.=A0 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.=A0 In any case, it doesn't work.=A0 I've searched the postgres
FAQs, TODO and mailing list archives, but can't find a mention of
this.
Thanks
Thom