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

From: "Verhaag Geert (GEN)" <g(dot)verhaag(at)maastrichtuniversity(dot)nl>
To: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, "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:10:56
Message-ID: 7FCA833E5B2A2E4D96EBEAB1E5C1009907B87D1F93@UM-MAIL4112.unimaas.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)albe(at)wien(dot)gv(dot)at]
Sent: Tuesday, November 26, 2013 13:03
To: Verhaag Geert (GEN); pgsql-admin(at)postgresql(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message joka veera Venkataramana 2013-11-26 16:28:00 Backup of database
Previous Message Albe Laurenz 2013-11-26 12:03:07 Re: Unable to fire up the server when modifying client authentication setting!