Cron job doing VACUUM and BACUP from root

From: "Aage J(dot) Skjolingstad" <aages(at)aajs(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Cron job doing VACUUM and BACUP from root
Date: 2000-11-04 19:29:53
Message-ID: 3A0463B1.4E8A3CB6@aajs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Dave Page 2000-11-04 20:37:52 RE: Cron job doing VACUUM and BACUP from root
Previous Message Eckhard Hoeffner 2000-11-04 16:57:08 StarOffice