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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
