Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: SebDate: 2008-03-28 03:32:05
Subject: extract day from interval
Previous:From: David TDate: 2008-03-28 03:10:39
Subject: Persistent user-defined functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group