How to setup Active Directory users in Postgres 9.3.11 - Mailing list pgadmin-support

From Wyatt Sanford
Subject How to setup Active Directory users in Postgres 9.3.11
Date
Msg-id BY2PR09MB099804CBB6586A1C77E0F522C1B20@BY2PR09MB0998.namprd09.prod.outlook.com
Whole thread Raw
Responses Re: How to setup Active Directory users in Postgres 9.3.11
List pgadmin-support
<div class="WordSection1"><p class="MsoNormal">Hi,<p class="MsoNormal"> <p class="MsoNormal">I have recently been
taskedwith installing Postgres 9.3.11 on a Windows 2012 R2 server on Active Directory and restoring backups from a
Linuxserver running Postgres 9.3.11.  I have all of the databases restored to the windows server and now I need to set
upaccess for users on Active Directory.  I’ve read a few things online, but did not find any good examples.  I know
thatyou have to add login roles in Postgres for each AD user that will need to connect, but I haven’t found any good
examplesof how to edit the pg_hba.conf file to accept AD connections.  The Postgres.conf file is already listening on
allports.  Can anyone give me some examples of the entries I need to add to the pg_hba.conf file or point me to some
exampleson the web.<p class="MsoNormal"> <p class="MsoNormal">Thanks,<p class="MsoNormal"> <p class="MsoNormal"> <p
class="MsoNormal">WyattSanford<p class="MsoNormal">Database Administrator<p class="MsoNormal">Mississippi Department of
Revenue<pclass="MsoNormal"> </div><br /><br /><div style="font-size:9pt;  font-family:
'Calibri',sans-serif;">DISCLAIMER: This e-mail transmission is intended for the use of the individual or entity
addressedand may contain protected confidential information. If you are not the intended recipient or the employee or
agentresponsible for delivering the transmission to the intended recipient, any dissemination, forwarding, printing,
distribution,copying or use of this transmission is strictly prohibited. If you have received this transmission in
error,please notify the sender and delete this transmission.</div> 

pgadmin-support by date:

Previous
From: Frank Limpert
Date:
Subject: Default Values of Function Arguments are garbled if they contain a comma
Next
From: YuanyuanLiu
Date:
Subject: bug of import data into table in pgadminIII 1.20.0