Re: does anyone know what to use in pg_hba.conf that will allow me to run cronjobs with pg_dump?

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: does anyone know what to use in pg_hba.conf that will allow me to run cronjobs with pg_dump?
Date: 2009-02-10 19:39:15
Message-ID: 20090210193915.GX3008@frubble.xen.chris-lamb.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Feb 10, 2009 at 05:45:27PM +0000, Richard Huxton wrote:
> Jonathan Vanasco wrote:
> > i think i just need a METHOD for localhost only.
>
> You can either "trust" any connections from the local machine, or if
> that's too insecure use a .pgpass file.

If your database user has the same name as the user who is running the
cron job you could also use the "ident" authentication method.

Sam

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-02-10 19:41:11 Re: Good Delimiter for copy command
Previous Message Alban Hertroys 2009-02-10 18:22:29 Re: Slow database creation