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