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

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.

> The problem with this is that you eat up a lot of handles if you have
a
> lot of backends.

Yep. My logic was flawed, even worse is the fact you have to manage
multiple listeners [slaps forehead].

> > #define _WIN32_WINNT 0X0500
> This means the code listed won't work on NT4. But looking at this
> particular code, it doesn't appear to use anything Windows 2000+
> specific. But it's worth watching out for if NT4 support is wanted.

The code will work for NT4.

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

Merlin