Re: productive usage of PostgreSQL with Windows Server - Mailing list 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

@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