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 1l4OyC-0001kt-Ld for pgsql-admin@arkaria.postgresql.org; Tue, 26 Jan 2021 14:05:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l4Oy9-0007FP-Nt for pgsql-admin@arkaria.postgresql.org; Tue, 26 Jan 2021 14:05:21 +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 1l4Oy9-0007FH-6Z for pgsql-admin@lists.postgresql.org; Tue, 26 Jan 2021 14:05:21 +0000 Received: from mail-gv0che01on2096.outbound.protection.outlook.com ([40.107.23.96] helo=CHE01-GV0-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l4Oy1-0006JT-Pn for pgsql-admin@lists.postgresql.org; Tue, 26 Jan 2021 14:05:19 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=CqMhnaVnnnrXiYpeMe9Nr8Ukee8mjIJef3FaDs/o/iTpS+wvhs2MxWYgMA2db2+9YH2Z/1rwB5JYQRhymT+ZUq3KbozvqBzajKBXsQqJ5j3nu33E4odnFzdPHx5hnk3EkylEbaIFU/59mPpa1YyHKpraDKLVFsbJHwOWg5Drpoq/4wD4jS7759BgyVDrldUPYnIvA4FvMBaLa/0iLiLz533zq/e08LTIhUN2HB+EYtakk62IG5xXC6TKlJjcx9GvAyFM6HY1tOhjGHsmDGYvz6wqaHfg+CF9lG23Kzh8LNYdsAe+5tJaYkWfK8i85xgbE/kSpklGU9odO0ePj5HZJA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=ETszpy5O36Qi4F75wvpP+w+//tZAY30UBPZXvL1XKYs=; b=Bb00CGAPRDbjCgoQflTcVugtIx9oSYGAMuHFLnE+q9qfHfCoHXKAlWd1I17QiYKXMMlWeSezGryyxZD/0KdYFN4Ve4yt8CHVmpQ1XCHYIgda2ahzczNLyVDGkMZWIQsklA9nA4x47IBE4omcD/nmljvu7hYqXNdbqTAc0sVcK1PQtk51QSv096hxUPRoCsNKOrHyyz0xsm1EpYwJYiDgG6YNXC+beGCq+aYM4K8iO9TA+iDWAzUggjdb0P/ncEvECx5FszL10Ldbyv3Fghv13Fg2l2Zs3E6obYYZGGaFOWtzzrEk/tddIyfhJMKYRXSPDJ8HHP3JqLDX7NLegc1Yqg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=dbi-services.com; dmarc=pass action=none header.from=dbi-services.com; dkim=pass header.d=dbi-services.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dbi-services.com; s=selector2; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=ETszpy5O36Qi4F75wvpP+w+//tZAY30UBPZXvL1XKYs=; b=JDzNvZRo/XJlGGGde+3t6hRVPkBOYQuYhtdpBvNzY90Pb6E9Ks1uGHm5R0lIWPfmNja7QGMIHtP4sie3HQHOLIBmETC74I2qlynDpCWusHA8tVJHcnEb4Ryj2WgFF5PiN3lj+6+UDHihUoNgELzHBszwJOvqAsUO6k0i35XIgzI= Received: from ZRAP278MB0431.CHEP278.PROD.OUTLOOK.COM (2603:10a6:910:1f::5) by ZR0P278MB0235.CHEP278.PROD.OUTLOOK.COM (2603:10a6:910:35::6) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3805.16; Tue, 26 Jan 2021 14:05:10 +0000 Received: from ZRAP278MB0431.CHEP278.PROD.OUTLOOK.COM ([fe80::8034:d176:205e:c00e]) by ZRAP278MB0431.CHEP278.PROD.OUTLOOK.COM ([fe80::8034:d176:205e:c00e%5]) with mapi id 15.20.3784.019; Tue, 26 Jan 2021 14:05:10 +0000 From: "Karsten Lenz (KLE)" To: Michael Banck , Dirk Krautschick CC: "pgsql-admin@lists.postgresql.org" Subject: RE: productive usage of PostgreSQL with Windows Server Thread-Topic: productive usage of PostgreSQL with Windows Server Thread-Index: Adbzzxlp5d1EWlXMSYiBAqvWcNN/sAAC3fgAAARdsiA= Date: Tue, 26 Jan 2021 14:05:09 +0000 Message-ID: References: <601003e9.1c69fb81.9ac35.26bd@mx.google.com> In-Reply-To: <601003e9.1c69fb81.9ac35.26bd@mx.google.com> Accept-Language: en-CH, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: credativ.de; dkim=none (message not signed) header.d=none;credativ.de; dmarc=none action=none header.from=dbi-services.com; x-originating-ip: [178.82.169.200] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 646b322c-28fe-409a-5878-08d8c203648f x-ms-traffictypediagnostic: ZR0P278MB0235: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:7691; x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 7faw+FgXnTR8ubYtB1+oBSvOWGmK2BchxTwxN3cUxqeUnTSAYJnDDymdwcMgTf8oxYprb9Sut17L/F/RmlicEx1sG+7z+h5kPpyJhPN+TJhfXHDHTbpUotuEqu63b1hQsl5dpFXQgxcLacMJsBSnkAyqwq7wcZbjBmPN80EOgxTxgekuvMCDoFuN1mQdaTE6Cbs1MfQmFv+Snt0e2ih5F3n7lLtjUcVGJFXHYVCmg25K3l37FiugK4i4zjvEglLzRcWlO4P6N+zLwGuBhbednQlyvPSMP8Rv1x6uvNsiO31a3wHBjgPOvvD9nYx7pIXaVUB8S86SIupcxPD8TyO3zMnPrI5tbsferzG6ItpxWxTQRPPJY3X4KridoJHgqANIhEqpTqgdsGmEslZStwtMdA30YBo3MPDsVyyvBNa/OwLUo1qYyCu2xHeN8i88TuH44iGyMz1sPYd0VHzhLyG6gGmxPopgXL/ydGnU8VoO8BdMXboN36imqPrQDnj39jmVFJWaS5z7dvOMXRSUDGTObg== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:ZRAP278MB0431.CHEP278.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(346002)(366004)(76116006)(66946007)(66556008)(66476007)(86362001)(66446008)(64756008)(8936002)(4326008)(186003)(110136005)(53546011)(26005)(71200400001)(316002)(7696005)(5660300002)(8676002)(6506007)(83380400001)(2906002)(9686003)(33656002)(478600001)(966005)(45080400002)(83080400002)(52536014)(55016002);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata: =?iso-8859-1?Q?BZ0iH0RFhDnvWS1Vw/4Q6G2LVlFcwcAdR58yzv1kLJfwx4g0TA2tIr5oYl?= =?iso-8859-1?Q?d5n7oQmYt0YVd1t4zqFNDotq2Ads6XbF4Ts6K8FdERaCtLKJmmxfJOJRYo?= =?iso-8859-1?Q?Iuc1/qoR5Me+tOBlhmGQVgm+vq4LcoPR+p+zkfpZpBf2wodrK+cfHlU1H7?= =?iso-8859-1?Q?lUOZ1XfNnjvyQQdkS/HIntjqf+GbVlxmgdqDcP4nFyBz4ZJl/mWUSTOLx9?= =?iso-8859-1?Q?/K+16N3k6YlWluGqq5n4COYXOoap/L+cpiPiTxcu801ov4NyX93XKrQO5E?= =?iso-8859-1?Q?q1l56e+/LkUjQgPEcsSkUDGTYgTeNiWg6VZW7eVkl3RAzqoZ1xHqHBqyhG?= =?iso-8859-1?Q?jJL4X5KWPaYw+nNPCUhQQNKYwhZ0PU2dQ+APenYZezZGInG3FboAdr7mE2?= =?iso-8859-1?Q?+BslD6GuYPwY8KY1EqghjN2spMLIcbm3Ge2UXB6yvmshMoLk59wA3gBkkB?= =?iso-8859-1?Q?QU60OvRUgJbqh9MhVWJxKEbI/GUcFG7Ehe4fDt4fffJlQaKmME2/FggIsz?= =?iso-8859-1?Q?HtwooTSF3Py1yoJa0tM0/uJISD9CK3vo6R2Hj4nfd/rgYeRoaa+v29OEUi?= =?iso-8859-1?Q?zc0H5DQcomxCFCPIE9ORRa0bWYf2EfomGUmfp6QChou4KKUQk10jL/qhqB?= =?iso-8859-1?Q?K9N/+tBNdRU8mMwcS2HHi4y/cKM7/oZ5gaiR9eOmu89r3BYc5+5yt9bG+O?= =?iso-8859-1?Q?p4seRt/UhbZJ+WcNKLTwSfD2UcedT0dus889p8XrfhxlSaNFn2/kNzAgHd?= =?iso-8859-1?Q?ndIq7XtKHNB4BiUU1HOWG/iIOmsuYO9qXhwiAsy1qVfnOSMrEXCv6dkLS2?= =?iso-8859-1?Q?cTRHilgNjJuVD0OSgZcG5YD0XkUjWr4eY8NppyuSxTQGd+++fvk4YiH0Wr?= =?iso-8859-1?Q?qRkgn2szVW1CT+oKxofyHQ2II+i74ShYhm9GtLiwqlvMuKFc+1WgxXGcfb?= =?iso-8859-1?Q?De0yjqivQ6x69BvYYzs4UyBMB5/1VeJIea+dGdOjHe+UdyR27ugh9LltOf?= =?iso-8859-1?Q?LkL7EJLqZ5a1ztssgepFcFDgUzgLGn5qurJRe3S/i8tActcSrT+kkyRMK8?= =?iso-8859-1?Q?awxWnpeVa8GqJ1a2UZ3RMwd7GRfTSjuC/gLuTyM4PLq1?= x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: dbi-services.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: ZRAP278MB0431.CHEP278.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: 646b322c-28fe-409a-5878-08d8c203648f X-MS-Exchange-CrossTenant-originalarrivaltime: 26 Jan 2021 14:05:10.0014 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: b9c70613-b1ea-47b7-9fdd-e6f3a67ce75c X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 4GbFHR2hThYg+4ShL9h1f5QA5T3U5vKL3Vu5cgor23BrOIP74NigstHGunajqrpzFotoHyWIUODHbJjTWfzLV9mE0obVY+szZLwnukP0314= X-MS-Exchange-Transport-CrossTenantHeadersStamped: ZR0P278MB0235 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Yes, but Micrsosoft itself is switching to Linux with the Flexible Server o= ffering. https://blog.dbi-services.com/azure-database-for-postgresql/ Regards Karsten -----Original Message----- From: Michael Banck =20 Sent: Dienstag, 26. Januar 2021 12:59 To: Dirk Krautschick Cc: pgsql-admin@lists.postgresql.org Subject: Re: productive usage of PostgreSQL with Windows Server On Tue, Jan 26, 2021 at 11:20:10AM +0000, Dirk Krautschick wrote: > 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=20 > Windows. Or are there any references you may share regarding this. >=20 > 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=20 > always get the question about experience and references which I cannot pr= ovide at this time. Microsoft is running (at least parts of) their Azure Postgres-As-A- Service= offering on Windows; that is probably one of the larger Postgres-on-Window= s deployments. Michael -- Michael Banck Projektleiter / Senior Berater Tel.: +49 2166 9901-171 Fax: +49 2166 9901-100 Email: michael.banck@credativ.de credativ GmbH, HRB M=F6nchengladbach 12080 USt-ID-Nummer: DE204566209 Trompeterallee 108, 41189 M=F6nchengladbach Gesch=E4ftsf=FChrung: Dr. Michael Meskes, J=F6rg Folz, Sascha Heuer Unser Umgang mit personenbezogenen Daten unterliegt folgenden Bestimmungen:= https://www.credativ.de/datenschutz