Re: Postgresql Backup

On Wednesday 24 January 2007 20:57, "bala"  
wrote:
> '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?

Include the full path to pg_dumpall in the script.  
Make sure the postgres user can connect without a password or has an 
appropriate .pgpass file in it's home directory.

-- 
No matter how disastrously some government policy has turned out, anyone 
who criticizes it can expect to hear: 'But what would you replace it 
with?'  When you put out a fire, what do you replace it with?