Re: Automated Database Backups - Mailing list pgsql-general

From John Iliffe
Subject Re: Automated Database Backups
Date
Msg-id 1287341624.5188.11.camel@linuxprod2
Whole thread Raw
In response to Re: Automated Database Backups  (Raymond O'Donnell <rod@iol.ie>)
List 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@iol.ie
>


pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Constraint: string length must be 32 chars
Next
From: Karsten Hilbert
Date:
Subject: Re: Internationalisation of database content (text columns)