On Wed, Mar 26, 2008 at 10:02:45AM -0700, Steve Atkins wrote: > What's the psql equivalent of the "standard" use case of "vacuumdb -a"? > (If you don't know the answer, for both unix and windows, you don't get > to vote for removing vacuumdb). linux: psql -qAt -c "select E'\\\\connect ' || datname || E'\nvacuum;' from pg_database where datallowconn" | psql windows: psql -qAt -c "select E'\\connect ' || datname || E'\nvacuum;' from pg_database where datallowconn" | psql that's not actually complicated (i'm not saying it's nice, as it isn't). depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
