How to setup Active Directory users in Postgres 9.3.11

From: Wyatt Sanford <Wyatt(dot)Sanford(at)dor(dot)ms(dot)gov>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: How to setup Active Directory users in Postgres 9.3.11
Date: 2016-03-09 14:35:00
Message-ID: BY2PR09MB0998E97F59CE4BCBFC2E650CC1B30@BY2PR09MB0998.namprd09.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have recently been tasked with installing Postgres 9.3.11 on a Windows 2012 R2 server on Active Directory and restoring backups from a Linux server running Postgres 9.3.11. I have all of the databases restored to the windows server and now I need to set up access for users on Active Directory. I've read a few things online, but did not find any good examples. I know that you have to add login roles in Postgres for each AD user that will need to connect, but I haven't found any good examples of how to edit the pg_hba.conf file to accept AD connections. The Postgres.conf file is already listening on all ports. Can anyone give me some examples of the entries I need to add to the pg_hba.conf file or point me to some examples on the web.

Thanks,

Wyatt Sanford
Database Administrator
Mississippi Department of Revenue

DISCLAIMER : This e-mail transmission is intended for the use of the individual or entity addressed and may contain protected confidential information. If you are not the intended recipient or the employee or agent responsible 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-03-09 14:53:34 Re: create create of database of a particular name
Previous Message Chris Withers 2016-03-09 13:49:04 create create of database of a particular name