Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l4NOF-0006HB-Qu for pgsql-admin@arkaria.postgresql.org; Tue, 26 Jan 2021 12:24:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l4NOE-0004rr-Pg for pgsql-admin@arkaria.postgresql.org; Tue, 26 Jan 2021 12:24:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l4NOE-0004rY-4v for pgsql-admin@lists.postgresql.org; Tue, 26 Jan 2021 12:24:10 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l4NO7-0005Sb-7C for pgsql-admin@lists.postgresql.org; Tue, 26 Jan 2021 12:24:09 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id A9AE238050C; Tue, 26 Jan 2021 13:24:00 +0100 (CET) Received: from rs.plausibolo.de ([127.0.0.1]) by localhost (h2367442.stratoserver.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 6c5dqj7IenvY; Tue, 26 Jan 2021 13:24:00 +0100 (CET) Received: from [192.168.222.175] (unknown [145.253.118.26]) by rs.plausibolo.de (Postfix) with ESMTPSA id 6E8A738040A; Tue, 26 Jan 2021 13:24:00 +0100 (CET) Subject: Re: productive usage of PostgreSQL with Windows Server To: pgsql-admin@lists.postgresql.org References: From: Holger Jakobs Message-ID: <5e9f20fe-7789-2b08-b736-544ce30e6a92@jakobs.com> Date: Tue, 26 Jan 2021 13:23:59 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.6.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="xgUlZmxbwRsb2MOqKBlOZkqQrymZjEbR7" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --xgUlZmxbwRsb2MOqKBlOZkqQrymZjEbR7 Content-Type: multipart/mixed; boundary="R9RsULe8AtaEVZta5SHrJn9Zbo3VjeoRU"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: <5e9f20fe-7789-2b08-b736-544ce30e6a92@jakobs.com> Subject: Re: productive usage of PostgreSQL with Windows Server References: In-Reply-To: --R9RsULe8AtaEVZta5SHrJn9Zbo3VjeoRU Content-Type: multipart/alternative; boundary="------------E07B5869719F09492EB835CA" Content-Language: de-DE This is a multi-part message in MIME format. --------------E07B5869719F09492EB835CA Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: quoted-printable PostgreSQL on Windows is a viable option, although some extensions=20 aren't available. If server and client are on Windows, authentication can be done via=20 Active Directory. This has to be configured in pg_hba.conf and makes=20 single sign-on possible. AFAIK, this is the only real advantage of using Windows. But it shows=20 that the PostgreSQL people offer this, although they had to program=20 Windows-specific code to make it work. I can tell that there is a company running a couple of thousand=20 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=20 > 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=20 > that there > > are also customers with more Windows knowledge inhouse I always get=20 > 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=20 > and suppported at > > least. But I am interessted in fundational opinions and expierences. > > Thanks and cheers > > Dirk > --=20 Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012 --------------E07B5869719F09492EB835CA Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

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,

=C2=A0=

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.

=C2=A0=

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.

=C2=A0=

Regarding the build farm= status I see that it is pretty much tested and suppported at<= o:p>

least. But I am interess= ted in fundational opinions and expierences.

=C2=A0=

Thanks and cheers

=C2=A0=

Dirk 

--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
--------------E07B5869719F09492EB835CA-- --R9RsULe8AtaEVZta5SHrJn9Zbo3VjeoRU-- --xgUlZmxbwRsb2MOqKBlOZkqQrymZjEbR7 Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCYBAJ3wUDAAAAAAAKCRCKV5yTsxlhunhb AKDic8p6ihPE32XvfpQ0qt+8Rnh+RgCgq92ync7pSYMsGlrCwjR3cPnYFSU= =MSF3 -----END PGP SIGNATURE----- --xgUlZmxbwRsb2MOqKBlOZkqQrymZjEbR7--