Обсуждение: Unable to fire up the server when modifying client authentication setting!

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

Hi Laurenz,

Thank you very much for helping me with this rather trivial issue, sorry!

Of course, you are perfectly right about the ' ident' authentication, I missed that completely!

Sorry!!

Regards,
Gerard

-----Original Message-----
From: Albe Laurenz [mailto:laurenz.albe@wien.gv.at] 
Sent: Tuesday, November 26, 2013 13:03
To: Verhaag Geert (GEN); pgsql-admin@postgresql.org
Subject: RE: Unable to fire up the server when modifying client authentication setting!

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