Home > mailing lists

pg_dump from crontab - Mailing list pgsql-admin

From	Nirav Parikh
Subject	pg_dump from crontab
Date	August 10, 2006 18:38:28
Msg-id	221385EC3F18A44DB0925467A1D2395F568D6D@exsrv3.workskillsprofessionals.com.au Whole thread Raw
Responses	Re: pg_dump from crontab Re: pg_dump from crontab Re: pg_dump from crontab Re: pg_dump from crontab
List	pgsql-admin

Hi,

I am having problem backing up database from crontab, I got following lines in crontab file

0 20 * * 5 /usr/pgsql/bin/pg_dump -F c database > /usr/backup/friDATE4.pgdump
0 20 * * 4 pg_dump -F c database > /usr/backup/thurDATE06-3.pgdump

none of them works, I have given full permission to everyone in /usr/backup directory

it creates the dump file but with 0 size - empty!

I have other commands in crontab which executes normally, also pg_dump command works through command line.

does anyone what else I can check?

Nirav

pgsql-admin by date:

From: Christoph Simon
Date: 10 August 2006, 18:38:23
Subject: data for 64bits on 32

From: Alexander Burbello
Date: 10 August 2006, 18:38:42
Subject: Find out foreign key