Re: psql: IDENT authentication failed for user 'js'

[Meir Kriheli <mksoft@netvision.net.il>]

On Saturday 06 October 2001 01:29, Johann Spies wrote:
> On Woody  - postgresql_7.1release-4_i386.de
>
> After upgrading to woody I had the following problem with posgtresql:
>
>
> As user postgres:
> -----------------------------------
> postgres@spyker:$ createuser js
> Shall the new user be allowed to create databases? (y/n) y
> Shall the new user be allowed to create more new users? (y/n) y
> CREATE USER
> postgres@spyker:$ exit
> exit
> --------------------------------------
>
> Now, as user:
> ---------------------
> $createdb js
> psql: IDENT authentication failed for user 'js'
> createdb: database creation failed
> js-23:21:12-~$
> ---------------------
>
> Why does this happen? I never had it before.
>
>
>
> Johann

The file /etc/postgresql/pg_hba.conf defines the authentication methods.

Change the authentication method from ident to whatever you want (This file 
contains all the documentation you need).

-- 
Meir Kriheli