Re: Postgresql Backup - Mailing list pgsql-general

From Alan Hodgson
Subject Re: Postgresql Backup
Date
Msg-id 200701261211.29403@hal.simkin.ca
Whole thread Raw
In response to Postgresql Backup  ("bala" <kbalavignesh@gmail.com>)
List pgsql-general
On Wednesday 24 January 2007 20:57, "bala" <kbalavignesh@gmail.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?


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: too many trigger records found for relation "item" -
Next
From: "Jeremy Haile"
Date:
Subject: Re: Stats collector frozen?