Re: Re: Survey: renaming/removing script binaries (createdb, createuser...)

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-general(at)postgresql(dot)org, depesz(at)depesz(dot)com
Cc: Steve Atkins <steve(at)blighty(dot)com>
Subject: Re: Re: Survey: renaming/removing script binaries (createdb, createuser...)
Date: 2008-03-28 03:30:57
Message-ID: 200803272330.59591.xzilla@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 26 March 2008 16:03, hubert depesz lubaczewski wrote:
> 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).
>

I have to think that a better solution for someone whose needs are met by the
above is to just enable autovacuum.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Seb 2008-03-28 03:32:05 extract day from interval
Previous Message David T 2008-03-28 03:10:39 Persistent user-defined functions