From: | John Iliffe <john(dot)iliffe(at)iliffe(dot)ca> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Automated Database Backups |
Date: | 2010-10-17 18:53:44 |
Message-ID: | 1287341624.5188.11.camel@linuxprod2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)iol(dot)ie
>
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Verite | 2010-10-17 20:50:27 | Re: installing from source in Windows |
Previous Message | Rob Sargent | 2010-10-17 16:42:54 | Re: Constraint: string length must be 32 chars |