Re: [HACKERS] [PATCHES] fork/exec patch

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: pgsql-hackers-win32 <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: [HACKERS] [PATCHES] fork/exec patch
Date: 2003-12-16 16:48:12
Message-ID: 3FDF374C.4040701@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32

Merlin Moncure wrote:
> Magnus Hagander wrote:
>
>>I haven't used message handlers in a long time, but can you use them
>
> at
>
>>all unless you are on the desktop? Meaning the Interact With Desktop
>>switch would be required, which in turn rules out any other user than
>>Local System. And that's the same as running as root on Unix, which is
>>something postgresql refuses.
>>Postgresql on windows shuold *definitly* support running with a low
>>privilege account.
>
>
> I wasn't sure if (while interactivity set to off) the postmaster would
> be blocked from sending messages to backends. Requirement in this
> setting should be avoided (google reports all kinds of problems with
> various applications, including IIS).
>
> As for Local System, most important services on win32 log on as Local
> System by default. Apache, mysql, etc. (I think, even SQL server) are
> all configured to run this way, mostly because it causes less hassles
> for the typical win32 user. Of course, you can lock everything down
> after installation. Assumptions are just fundamentally different on
> win32.

initdb.c specifically avoids checking for running as root (or
administrator) on Windows. I assumed the service would run from a
privileged account.

BTW, is anyone working on building in code to run as a service? Or do we
plan to use a service wrapper?

>
>>Is there a decision on which platforms should be supported, other than
>>it's NT4+?
>
>
> Personally, I could care less if 95, 98, or ME are supported, and
> neither will the vast majority of win32 IT folks. IIRC, NT4 supports
> everything we need. I wouldn't worry about it too much.

Agreed. NT4+ or even W2K+ should be acceptable. 95/98/ME are all EOLed
now anyway, aren't they?

cheers

andrew

In response to

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Steve Tibbett 2003-12-16 16:50:25 Re: [HACKERS] [PATCHES] fork/exec patch
Previous Message Magnus Hagander 2003-12-16 16:45:53 Re: [HACKERS] [PATCHES] fork/exec patch