Re: Unable to fire up the server when modifying client authentication setting! - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: Unable to fire up the server when modifying client authentication setting!
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17C601E5@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Unable to fire up the server when modifying client authentication setting!  ("Verhaag Geert (GEN)" <g.verhaag@maastrichtuniversity.nl>)
Responses Re: Unable to fire up the server when modifying client authentication setting!  ("Verhaag Geert (GEN)" <g.verhaag@maastrichtuniversity.nl>)
List pgsql-admin
Verhaag Geert wrote:
> I’m currently using version 8.4, and installed everything seems to work properly.
> 
> However, I’m having trouble with setting client authentication properly!
> 
> Client authentication is controlled by the configuration file named pg_hba.conf.
> 
> When I add the option map=myname  like this:
> 
> local   all         all                               trust    map=myname
> 
> to the file mentioned above the server won’t fire up anymore! No messages in the log?
> 
> By the way I added myname to the pg_ident.conf file like:
> 
> # MAPNAME     SYSTEM-USERNAME    PG-USERNAME
> myname             systemusername          pgusername
> 
> What is wrong here?

I guess you want "ident" authentication.
You should replace "trust" with "ident".

By the way, you don't need to restart the server for such a change.
Using "pg_ctl reload" to send a SIGHUP would do the trick.

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: "Verhaag Geert (GEN)"
Date:
Subject: Unable to fire up the server when modifying client authentication setting!
Next
From: "Verhaag Geert (GEN)"
Date:
Subject: Re: Unable to fire up the server when modifying client authentication setting!