How to setup Active Directory users in Postgres 9.3.11 - Mailing list pgsql-general

From Wyatt Sanford
Subject How to setup Active Directory users in Postgres 9.3.11
Date
Msg-id BY2PR09MB0998E97F59CE4BCBFC2E650CC1B30@BY2PR09MB0998.namprd09.prod.outlook.com
Whole thread Raw
Responses Re: How to setup Active Directory users in Postgres 9.3.11  (Giuseppe Sacco <giuseppe@eppesuigoccas.homedns.org>)
List 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.

pgsql-general by date:

Previous
From: Chris Withers
Date:
Subject: create create of database of a particular name
Next
From: Adrian Klaver
Date:
Subject: Re: create create of database of a particular name