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

how to vacuum from cron?

From: John Madden <weez(at)freelists(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: how to vacuum from cron?
Date: 2001-02-28 23:10:19
Message-ID: 0102281810195V.13156@weez (view raw or flat)
Thread:
Lists: pgsql-general
I guess the subject says it all -- what's the easiest way to do a vacuum 
(say, nightly) if you're not allowing "trust" from local unix sockets?  
(Counting out, of course, putting a password in any files...)

Thanks,
 John





-- 
# John Madden  weez(at)freelists(dot)org ICQ: 2EB9EA
# FreeLists, Free mailing lists for all: http://www.freelists.org
# UNIX Systems Engineer, Ivy Tech State College: http://www.ivy.tec.in.us
# Linux, Apache, Perl and C: All the best things in life are free!

Responses

pgsql-general by date

Next:From: Joseph ShraibmanDate: 2001-02-28 23:12:38
Subject: Re: 7.0 vs 7.1 running select count(*) FROM table WHERE (SELECT count(*) ) > 0;
Previous:From: Oliver ElphickDate: 2001-02-28 22:31:27
Subject: Re: pg_dumpall -> fails

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