Postgresql Backup - Mailing list pgsql-general

From bala
Subject Postgresql Backup
Date
Msg-id 1169701055.626199.318220@v33g2000cwv.googlegroups.com
Whole thread Raw
Responses Re: Postgresql Backup  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-general
Hello frends!

 i am using postgresql database. I am using crond for daily backup.

Following is the crontab entry,

29 17 * * 1-6  postgres  /path/to/script.sh

'script.sh'   contains

PGUSER=postgres  pg_dumpall > /path/to/backup_date.sql

Running the script using crond creates the 0 byte files.

But , If i run the script in console , it creates the file with
content.

Any suggestion pls?

Regards

Bala


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Stats collector frozen?
Next
From: "Kai Schlamp"
Date:
Subject: relationship in a table