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