Обсуждение: How to setup Active Directory users in Postgres 9.3.11
<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>
On 08/03/2016 17:56, Wyatt Sanford wrote: > 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 Hi there, You'd be better off asking on the pgsql-general mailing list. This one is dedicated to PgAdmin, the PostgreSQL administration tool. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
Thanks, I'll do that. Wyatt Sanford Database Administrator -----Original Message----- From: Raymond O'Donnell [mailto:rod@iol.ie] Sent: Wednesday, March 09, 2016 4:54 AM To: Wyatt Sanford; 'pgadmin-support@postgresql.org' Subject: Re: [pgadmin-support] How to setup Active Directory users in Postgres 9.3.11 On 08/03/2016 17:56, Wyatt Sanford wrote: > 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 Hi there, You'd be better off asking on the pgsql-general mailing list. This one is dedicated to PgAdmin, the PostgreSQL administrationtool. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie DISCLAIMER : This e-mail transmission is intended for the use of the individual or entity addressed and may contain protectedconfidential information. If you are not the intended recipient or the employee or agent responsible for deliveringthe transmission to the intended recipient, any dissemination, forwarding, printing, distribution, copying or useof this transmission is strictly prohibited. If you have received this transmission in error, please notify the senderand delete this transmission.