Bug#491845: openser-postgres-module: Postgres auth problem with openserdbctl

[Julien BLACHE]

notfound 491845 1.3.2-2
close 491845
thanks

Alexander Beisig <abeisig at speech-design.de> wrote:

Hi,

> The openserdbctl utility asked me for the password for the superuser
> "postgres", but on my system the user "postgres" doesn't have a
> password set and uses ident authentication over the local unix socket
> instead.  I think this is the Debian default, too.
>
> To make the authentication work without setting a password for the
> superuser, I disabled the "-h $DBHOST" option to psql for local
> connections.  These connections will then use the unix socket and
> ident authentication will work as intended.

You should set DBROOTUSER and/or create ~/.pgpass.

JB.

-- 
 Julien BLACHE - Debian & GNU/Linux Developer - <jblache at debian.org> 
 
 Public key available on <http://www.jblache.org> - KeyID: F5D6 5169 
 GPG Fingerprint : 935A 79F1 C8B3 3521 FD62 7CC7 CD61 4FD7 F5D6 5169