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!

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

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.
>


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq