Postgresql in Active Directory Machine

Question

Hi u all,

I have a server in wich is installed Postgresql. In this server i want to install theMicrosoft Active Directory. Can i do this without a problems? Can i change the user that run the Postgresql service without a problem?

When i installa the AD all the machine users will be deleted so i need to create domain users to run that service.

PLS Help Me

Answer 1

It will work, but there could be performance issues since you're basically running two databases on the same machine.

It's a risk that the upgrade will remove the PostgreSQL service user. In this case, you will jus thave to create a new one and assign it to the service. Another option is to uninstall PostgreSQL (this will not uninstall the data), turn the machine into an AD controller, and then reinstall PostgreSQL (same version!). It will then pick up the old data directory automatically.

Answer 2

Thanks.

Everything goes well.