Thread: run postgres.exe as a Windows Administrative account

All,

I am new to postgreSQL and the first time I tried to execute
postgres.exe I got an error saying the services must be started as a
non-administrative windows user. But I checked the doc and it says
after 8.2 it is possible to run postgres.exe as a windows
administrator. So a little bit confused, is it possible, if so, how?

Thanks a lot for help!

Hi,
don't confuse the user who initiates the starting process of the DB
(double click on the icon) with the one the DB runs under.

As far as I know, there should be an unprivileged user e.g. "postgres".
"administrator" starts postmaster in the unprivileged context of
"postgres" when you start it manually while being logged in as
"administrator" or when the service gets automatically started at boot time.

At least this is how an PG 8.2.4 runs here.


Yingqi Tang schrieb:
> I am new to postgreSQL and the first time I tried to execute
> postgres.exe I got an error saying the services must be started as a
> non-administrative windows user. But I checked the doc and it says
> after 8.2 it is possible to run postgres.exe as a windows
> administrator.
>