Re: BUG #1245: Postgres won't start - Mailing list pgsql-bugs

From Harald Armin Massa
Subject Re: BUG #1245: Postgres won't start
Date
Msg-id 7be3f35d04090803212560900@mail.gmail.com
Whole thread Raw
In response to BUG #1245: Postgres won't start  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
List pgsql-bugs
> PostgreSQL won't start because I'm logged on as a user with administrative
> rights.

That has be discussed in great detail during the pre-beta period. All
the arguments you do provide are quite correct and all of them have
been considered and discussed.

I myself did argue for "PostgreSQL as Admin on windows", with similiar
arguments as you.

core developers of PostgreSQL made it clear that PostgreSQL as Admin
will not happen in the official distribution. The arguments where
compelling and correct: MS itself is going that way of "non Admin" and
security

So your options are threefold:

a) create a user with limited privileges and run postgresql as this
user. (HINT: You can also runas /user:lowpriv cmd.exe and you will
have a suitable commandline(
[a is recommended]

The PostgreSQL MSI Binary installer is doing this job for you quite well.


b) patch the source to allow postgresql as Admin [not recommended]

c) dump postgresql [also not recommended]

Best wishes

Harald

pgsql-bugs by date:

Previous
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1245: Postgres won't start
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1246: not exist pltcl.so in postgresql rpm package