Re: Run PostgreSQL with Administrator account in Windows

Started by Joshua D. Drakeabout 20 years ago4 messagesgeneral
Jump to latest
#1Joshua D. Drake
jd@commandprompt.com

Michael Louie Loria wrote:

Hello,

How do I run PostgreSQL with Administrator account in Windows?

I know this is a security issue but I just want to test it in my
Administrator account.

You can't. It is a security issue and we don't allow it.

Joshua D. Drake

Thanks,

Michael Louie Loria
LoRz Technology Solutions
http://www.lorztech.com

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Joshua D. Drake (#1)

"Joshua D. Drake" <jd@commandprompt.com> writes:

Michael Louie Loria wrote:

How do I run PostgreSQL with Administrator account in Windows?

You can't. It is a security issue and we don't allow it.

FYI, there is code in CVS HEAD to allow starting the postmaster from
an admin account via pg_ctl: pg_ctl will give up admin privileges before
launching the postmaster, thereby closing the security hole.

regards, tom lane

#3Michael Louie Loria
mlloria@lorztech.com
In reply to: Joshua D. Drake (#1)

Joshua D. Drake wrote:

You can't. It is a security issue and we don't allow it.

Joshua D. Drake

Thanks Joshua. that was a quick response.

Michael Louie Loria
LoRz Technology Solutions
http://www.lorztech.com

#4Michael Louie Loria
mlloria@lorztech.com
In reply to: Tom Lane (#2)

Tom Lane wrote:

"Joshua D. Drake" <jd@commandprompt.com> writes:

Michael Louie Loria wrote:

How do I run PostgreSQL with Administrator account in Windows?

You can't. It is a security issue and we don't allow it.

FYI, there is code in CVS HEAD to allow starting the postmaster from
an admin account via pg_ctl: pg_ctl will give up admin privileges before
launching the postmaster, thereby closing the security hole.

regards, tom lane

I was thinking of that but I'm new to PostgreSQL so I still don't know
how to compile it. Currently checking
http://www.postgresql.org/docs/faqs.FAQ_MINGW.html and subscribing to
pgsql-hackers. Thanks

Michael Louie Loria
LoRz Technology Solutions
http://www.lorztech.com