Re: Crontab problem with backup

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Crontab problem with backup
Date: 2006-04-15 03:24:28
Message-ID: 200604142024.28383@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On April 14, 2006 06:58 pm, Kirti <kirti(at)unswalumni(dot)com> wrote:

> What logs do I need to check to find the problem?

Wherever your system logs the output from cron. RedHat Linux and
derivatives will have a /var/log/cron or something similar (if you happen
to be running Linux). The postgres user probably got email about it, too.

> What might be a way to
> test the script?

su - postgres
run the command

This will uncover most problems, outside of obscure path differences between
a normal login session and what cron provides. Also make sure the user is
allowed to execute cron jobs.

Your cron log most likely will tell you what went wrong, though.

--
Alan

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2006-04-15 04:18:59 Re: Crontab problem with backup
Previous Message Kirti 2006-04-15 01:58:03 Crontab problem with backup