From: | Holger Jakobs <holger(at)jakobs(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: productive usage of PostgreSQL with Windows Server |
Date: | 2021-01-26 12:23:59 |
Message-ID: | 5e9f20fe-7789-2b08-b736-544ce30e6a92@jakobs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
PostgreSQL on Windows is a viable option, although some extensions
aren't available.
If server and client are on Windows, authentication can be done via
Active Directory. This has to be configured in pg_hba.conf and makes
single sign-on possible.
AFAIK, this is the only real advantage of using Windows. But it shows
that the PostgreSQL people offer this, although they had to program
Windows-specific code to make it work.
I can tell that there is a company running a couple of thousand
PostgreSQL installations on Windows for a couple of years and that there
haven't been any problems.
Regards,
Holger
Am 26.01.21 um 12:20 schrieb Dirk Krautschick:
>
> Hi,
>
> Please do not throw anything to me but I just want to ask if there is
> a realistic
>
> recommendation for the productive usage of PostgreSQL with Windows. Or
>
> are there any references you may share regarding this.
>
> I am aware and I always surely recommend Linux but the matter of fact
> that there
>
> are also customers with more Windows knowledge inhouse I always get
> the question
>
> about experience and references which I cannot provide at this time.
>
> Regarding the build farm status I see that it is pretty much tested
> and suppported at
>
> least. But I am interessted in fundational opinions and expierences.
>
> Thanks and cheers
>
> Dirk
>
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
From | Date | Subject | |
---|---|---|---|
Next Message | Bo Victor Thomsen | 2021-01-26 13:01:11 | Re: productive usage of PostgreSQL with Windows Server |
Previous Message | Michael Banck | 2021-01-26 11:58:32 | Re: productive usage of PostgreSQL with Windows Server |