Groups > comp.databases.postgresql > #563

Ident authentication failed

From	Magnus Warker <warker@mailinator.com>
Newsgroups	comp.databases.postgresql
Subject	Ident authentication failed
Date	2014-05-14 10:09 +0200
Organization	albasani.net
Message-ID	<lkv8cj$9qd$1@news.albasani.net> (permalink)

Show all headers | View raw

Hi,

I have prepared my postgresql installation so that a user "www" can 
connect to a database using psql -Uwww -W -d datbase.

If I do this when logged in as "www" it works. If I do it when logged in 
as root (but still with -Uwww), I get the error message:

Ident authentication failed for user "www"

How can I change this?

In general I want to be able to connect to a database using username and 
password, no matter who is logged in.

I found that authentication is somewhat special in postgresql, e. g. 
that a user can connect to a database without authentication/password. 
What's the idea behind this?

Thanks
Magnus

-- 
This is Unix-Land. In quiet nights, you can hear the Windows machines 
reboot.

Back to comp.databases.postgresql | Previous | Next — Next in thread | Find similar

Thread

Ident authentication failed Magnus Warker <warker@mailinator.com> - 2014-05-14 10:09 +0200
  Re: Ident authentication failed Rainer Weikusat <rweikusat@mobileactivedefense.com> - 2014-05-14 11:56 +0100

csiph-web