How can I run PostgreSQL DB service under Local System account?

Question

Hi,

I'm using PostgreSQL DB in my application, I used to create special windows user account to run the DB service.

Now I need to run PostgreSQL service under Local System account! Is there a configuration in PostgreSQL to specify the user account which the service runs under?

Thanks,

Answer 1

I don't believe that you need to do anything special to run this under a local system account. We use PostgreSQL databases here and we install them on local system accounts all the time. I have never seen a configuration setting in the installation that allows you to indicate a system account for the service.

Answer 2

Computer Management -> Services -> select the Postgres server service -> right click -> Properties -> check the Log on tab, just like any other Windows service.

(Might be a bit off with the naming, I don't have access to a Windows machine at home, but I'm sure you can improvise.)