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