Re: productive usage of PostgreSQL with Windows Server

Holger Jakobs <holger@xxxxxxxxxx> · Tue, 26 Jan 2021 13:23:59 +0100



    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
  

Attachment:
OpenPGP_signature

Description: OpenPGP digital signature