Thanks to those who replied to my post.
I tried that and works a treat!
Regards.
John
======================================================
On Sat, 2010-16-10 at 17:18 +0100, Raymond O'Donnell wrote:
> On 15/10/2010 22:12, John Iliffe wrote:
> > Does anyone have a way to run pg_dump from cron in a way that doesn't
> > require someone to enter the password on every run? I get the following
> > error even when the backup user has read permissions on all application
> > databases.
>
> You need to use a .pgpasss file:
>
> http://www.postgresql.org/docs/9.0/static/libpq-pgpass.html
>
> You can instead specify the password in an environment variable, but
> that potentially makes it visible to all users on the system, so the
> .pgpass is better.
>
> HTH,
>
> Ray.
>
>
> --
> Raymond O'Donnell :: Galway :: Ireland
> rod@iol.ie
>