Re: how to vacuum from cron? - Mailing list pgsql-general

From Tom Lane
Subject Re: how to vacuum from cron?
Date
Msg-id 19678.983411759@sss.pgh.pa.us
Whole thread Raw
In response to how to vacuum from cron?  (John Madden <weez@freelists.org>)
List pgsql-general
John Madden <weez@freelists.org> writes:
> 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...)

Perhaps do it across a local TCP connection and use ident to verify?

            regards, tom lane

pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Slowdown problem when writing 1.7million records
Next
From: Bruce Momjian
Date:
Subject: Re: Under Mac OS X