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:
@font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif;}span.E-MailFormatvorlage21 {mso-style-type:personal-compose; font-family:"Calibri",sans-serif; color:windowtext;}.MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;}div.WordSection1 {page:WordSection1;}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