Обсуждение: How to setup Active Directory users in Postgres 9.3.11
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
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.