Re: no password on postgres user and pgagent

From: Christoph Berg <myon(at)debian(dot)org>
To: Seb <spluque(at)gmail(dot)com>
Cc: pgsql-pkg-debian(at)postgresql(dot)org
Subject: Re: no password on postgres user and pgagent
Date: 2016-05-10 09:08:28
Message-ID: 20160510090828.GA7473@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-pkg-debian

Re: Seb 2016-05-10 <87r3daopfm(dot)fsf(at)otaria(dot)sebmel(dot)org>
> Hello,
>
> I'd like to run pgagent with the postgres user, which doesn't have a
> password. I thought it'd be as simple as setting up an init script as:
>
> [ -- Begin <pgagent_start.sh> ---------------------------------------------- ]
> #! /bin/sh
>
> pgagent user=postgres host=localhost dbname=postgres

The default pg_hba.conf requires md5 passwords for "host=localhost"
connections. If you remove that connection parameter, a passwordless
UNIX socket connection will be used. (In which case pgagent must be
running as the "postgres" OS user.)

Christoph

In response to

Responses

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message Sebastian P. Luque 2016-05-10 13:07:36 Re: no password on postgres user and pgagent
Previous Message Seb 2016-05-09 22:07:57 no password on postgres user and pgagent