pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: productive usage of PostgreSQL with Windows Server
Date: Tue, 26 Jan 2021 13:23:59 +0100
Message-ID: <5e9f20fe-7789-2b08-b736-544ce30e6a92@jakobs.com> (raw)
In-Reply-To: <AM0PR05MB60828507F7097170790AAF70E9BC0@AM0PR05MB6082.eurprd05.prod.outlook.com>
References: <AM0PR05MB60828507F7097170790AAF70E9BC0@AM0PR05MB6082.eurprd05.prod.outlook.com>

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

Attachments:

  OpenPGP_signature (application/pgp-signature, 202B) download

view thread (6+ messages)  latest in thread

Message-ID: <5e9f20fe-7789-2b08-b736-544ce30e6a92@jakobs.com>
Permalink:  ../5e9f20fe-7789-2b08-b736-544ce30e6a92@jakobs.com/
Also on:    postgresql.org/message-id/5e9f20fe-7789-2b08-b736-544ce30e6a92@jakobs.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: holger@jakobs.com, pgsql-admin@lists.postgresql.org
  Subject: Re: productive usage of PostgreSQL with Windows Server
  In-Reply-To: <5e9f20fe-7789-2b08-b736-544ce30e6a92@jakobs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox