| From: | "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | "Aage J(dot) Skjolingstad" <aages(at)aajs(dot)com> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: Cron job doing VACUUM and BACUP from root |
| Date: | 2000-11-05 00:06:47 |
| Message-ID: | 200011050006.eA506lm04352@linda.lfix.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
"Aage J. Skjolingstad" wrote:
>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.
| Attachment | Content-Type | Size |
|---|---|---|
| do.maintenance | text/plain | 1.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carolyn Lu Wong | 2000-11-05 06:58:15 | Need help with ODBC error |
| Previous Message | Dave Page | 2000-11-04 20:37:52 | RE: Cron job doing VACUUM and BACUP from root |