Received: from kormt.aajs.com (kormt.aajs.com [206.180.155.162])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA4JTvs75808
	for <pgsql-interfaces@postgresql.org>;
	Sat, 4 Nov 2000 14:29:57 -0500 (EST) (envelope-from aages@aajs.com)
Received: from mili.aajs.com ([206.180.155.163] helo=aajs.com)
	by kormt.aajs.com with esmtp (Exim 3.16 #1) id 13s91R-0002JP-00
	for pgsql-interfaces@postgresql.org; Sat, 04 Nov 2000 13:30:37 -0600
Message-ID: <3A0463B1.4E8A3CB6@aajs.com>
Date: Sat, 04 Nov 2000 13:29:53 -0600
From: "Aage J. Skjolingstad" <aages@aajs.com>
X-Mailer: Mozilla 4.74 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Cron job doing VACUUM and BACUP from root
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200011/64
X-Sequence-Number: 100

Have been searching around the last two days to find some scripts or
cron jobs to automate backup and vacuum.

I'm running a small db on PSQL 7.02 / RH 7 and keeping my login as
root.

I know how to set up cron from root and I believe it should be
possible to call the job from root, or am I totally wrong. 

For what I have been doing I only get FATAL 1 errors, believe that's
from not being in su postgres ?

Any help and assistance (step by step) to a novice would be helpful. 

Regards,

Aage J. Skjolingstad