pg dump.. issue with when using crontab

From: Moe <mohamed5432154321(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg dump.. issue with when using crontab
Date: 2010-01-26 16:54:31
Message-ID: 861fed221001260854x355c62dbh622b6aea8e5a6208@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi folks,

I have a simple script file db :
#!/bin/bash
pg_dump -U postgres prodDB > /var/a/db/$(date "+%Y-%m-%d_%H:%M")-prodDB.dump

----------
Which works fine when executed manually ( ./db ).. I get a dump file which
is around 1.9 MB

I run this script from the crontab schedueler (crontab -e) :

# m h dom mon dow command
33 04 * * * /var/a/scripts/db

Which appears to executing the script file, but what I get is zero sized
dump files.
So perhaps it is some use access that is limiting crontab, making it not run
as root.

How can I fix this to work with crontab ? I am thinking that I should change
:
pg_dump -U postgres prodDB > /var/a/db/$(date "+%Y-%m-%d_%H:%M")-prodDB.dump

Thank you in advance / Moe

Responses

Browse pgsql-general by date

  From Date Subject
Next Message APseudoUtopia 2010-01-26 17:07:15 Re: pg dump.. issue with when using crontab
Previous Message Tom Lane 2010-01-26 16:48:02 Re: Make & Install contrib/tablefunc Problems