Re: [PATCHES] Open Items

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Zeugswetter Andreas DAZ SD" <ZeugswetterA(at)spardat(dot)at>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>, <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [PATCHES] Open Items
Date: 2004-11-02 12:38:26
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE456A45@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

> > > > o fix shared memory on Win2k terminal server
> > > >
> > > > We might be able to just mark this as not supported.
>
> The shmem code works in a terminal server session with or
> without the patch.
> Magnus had a different problem, probably permissions. Since I
> do not have a non admin user (on a TS server) I disabled the
> win32_is_admin check.

Ok. That explains why it didn't work for me - it wasn't intended to
solve the problem I was looking at.

> It is my opinion that we should allow pg to run as Admin on
> Windows, at least with an override option. Services that run
> under a specified user are a headache on Win32, because you
> need to store a password, and a lot of systems only have one user.

That is a different issue alltogether. But really - install from the
installer and it will handle these things for you. And keeping one extra
password in your safe storage is not going to make much difference...
But again, different issue.

> > > I have attached a patch that I think fixes this. The
> problem I saw
> > > and fixed is, that the shmem created in a terminal
> services client
> > > is not visible to the console (or services.msc).
>
> The decision is simple. If we want the shmem to be global on
> the machine we need the patch. I think we want that, but can
> not give an authoritative answer.

Right. Looking at the patch from that POV, it certainly seems
reasonable. The issue otherwise is that one pg installation running in a
TS session could conflict with one running as a service, for example.
(The postmaster-already-up-detection breaks)

(This only applies to commandline-started things, services *always* use
the global namespace by default)

Just one question about the actual implementation of the patch - why are
you setting the OS version *before* you call GetVersionEx()? It'll just
get overwritten...

> > > I think in addition the system global name "sharemem.1" should be
> > > made more pg specific, like "PostgreSQL.1". I have not done this
> > > since a new compile would not detect a running old beta.
> But now would be the time (or never).
>
> I think all agreed that this is good.

Yes. Definitly. For stuff in the global namespace it's definitly
preferred if you can relate to which app/server it belongs.

//Magnus

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2004-11-02 12:53:54 Re: charset/collation in values
Previous Message Dennis Bjorklund 2004-11-02 12:15:45 Re: charset/collation in values

Browse pgsql-patches by date

  From Date Subject
Next Message Zeugswetter Andreas DAZ SD 2004-11-02 13:20:45 Re: [PATCHES] Open Items
Previous Message Joshua D. Drake 2004-11-02 11:33:02 Re: [PATCHES] Open Items