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
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! |