From: Greg Williamson <gwilliamson39@yahoo.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Cronjob to autobackup database
Date: Wed, 5 Dec 2012 19:26:13 -0800 (PST)
Message-ID: <1354764373.34260.YahooMailNeo@web125903.mail.ne1.yahoo.com> (raw)
In-Reply-To: <1354754355699-5735397.post@n5.nabble.com>
References: <1354583597299-5734873.post@n5.nabble.com>
<1354754355699-5735397.post@n5.nabble.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
A question --
>________________________________
> From: teyking2003 <tchongking@hotmail.com>
>To: pgsql-admin@postgresql.org
>Sent: Wednesday, December 5, 2012 4:39 PM
>Subject: Re: [ADMIN] Cronjob to autobackup database
>
>i copy this copy inside etc/cron.daily/autopgdump.sh and put in the full
>directory path and wait until 930am. but nothing has been process.
>
>do we need to setup special permission for this .SH file?
>
If you copy the command exactly as the cron entry shows it, and, as the user who runs the cron job, paste it onto the command line and run it; what does the command do ?
If it runs from the command line, a few possibilities occur to me --
a) you didn't set the time to what you thought you did (been there, done that, easy to do).
b) Some missing part that the user's environment is providing (an ENV var, for example) but the cron job would not know about.
If it does not run from the command line, that will probably give you a clue.
HTH,
Greg Williamson
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gwilliamson39@yahoo.com
Subject: Re: Cronjob to autobackup database
In-Reply-To: <1354764373.34260.YahooMailNeo@web125903.mail.ne1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox