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)