Re: Unable to fire up the server when modifying client authentication setting!

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Verhaag Geert (GEN) *EXTERN*" <g(dot)verhaag(at)maastrichtuniversity(dot)nl>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Unable to fire up the server when modifying client authentication setting!
Date: 2013-11-26 12:03:07
Message-ID: A737B7A37273E048B164557ADEF4A58B17C601E5@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Verhaag Geert (GEN) 2013-11-26 12:10:56 Re: Unable to fire up the server when modifying client authentication setting!
Previous Message Verhaag Geert (GEN) 2013-11-26 11:34:51 Unable to fire up the server when modifying client authentication setting!