Re: Postgresql Backup

On Wednesday 24 January 2007 20:57, "bala" <kbalavignesh(at)gmail(dot)com>
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?