Postgresql Backup

From: "bala" <kbalavignesh(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgresql Backup
Date: 2007-01-25 04:57:35
Message-ID: 1169701055.626199.318220@v33g2000cwv.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-01-25 05:53:51 Re: Example of RETURNING clause to get auto-generated keys
Previous Message Merlin Moncure 2007-01-25 04:44:30 Re: indexing primary and foreign keys w/lookup table