Subject: Re: Cronjob to autobackup database
Mime-Version: 1.0 (Apple Message framework v1283)
Content-Type: text/plain; charset=us-ascii
From: Spike Grobstein <spike@ticketevolution.com>
In-Reply-To: <1354583597299-5734873.post@n5.nabble.com>
Date: Tue, 4 Dec 2012 09:51:32 -0500
Cc: pgsql-admin@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <4422292F-040B-4DE8-AA2A-2A5F1C201B65@ticketevolution.com>
References: <1354583597299-5734873.post@n5.nabble.com>
To: teyking2003 <tchongking@hotmail.com>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

You can debug what's going wrong with the script by adding this:

30 09 * * * /autopgdump.sh &> /autopgdump.log

that will write the output of the command to a logfile living at /autopgdum=
p.log. If there's anything wrong with your environment (something not in th=
e PATH of the user running the cron, etc) it should be written there. Cron =
runs with a slightly different environment than a regular login shell, so t=
his can help you figure out exactly what's going wrong.

note: each time cron executes that script, it will replace the contents of =
/autopgdump.log; not append to it.

Also, just to double check, the above configuration would run the script at=
 9:30am every day, so did you wait until 9:30 for the script to run?


...spike


On Dec 3, 2012, at 8:13 PM, teyking2003 wrote:

> i  have a cronjob setting up as below
> 1)Command crontab -e=20
> 2)Keyin 30 09 * * * /autopgdump.sh
> 3) Save to new crontab file.
> but nothing happen, the backup process won't start.
>=20
> i manage to perform manual backup by running the following command
> sudo ./autopgdump.sh( SH file store under root directory
>=20
> looking for the correct ways to setting up the cronjob.
>=20
> thanks
>=20
>=20
>=20
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/Cro=
njob-to-autobackup-database-tp5734873.html
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>=20
>=20
> --=20
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin