Home > mailing lists

Re: Windows default locale vs initdb - Mailing list pgsql-hackers

From	Dave Page
Subject	Re: Windows default locale vs initdb
Date	April 19, 2021 17:26:46
Msg-id	CA+OCxow6QamraRTUvqnmRv6smxqDuahRSaVtg_3YmDdXZf-XSQ@mail.gmail.com Whole thread Raw
In response to	Re: Windows default locale vs initdb (Andrew Dunstan <andrew@dunslane.net>)
Responses	Re: Windows default locale vs initdb
List	pgsql-hackers

On Mon, Apr 19, 2021 at 11:52 AM Andrew Dunstan <andrew@dunslane.net> wrote:

My understanding from Microsoft staff at conferences is that Azure's PostgreSQL SAS runs on linux, not WIndows.

This is from a regular Azure Database for PostgreSQL single server:

postgres=> select version();

version

------------------------------------------------------------

PostgreSQL 11.6, compiled by Visual C++ build 1800, 64-bit

(1 row)

And this is from the new Flexible Server preview:

postgres=> select version();

version

-----------------------------------------------------------------------------------------------------------------

PostgreSQL 12.6 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.12) 5.4.0 20160609, 64-bit

(1 row)

So I guess it's a case of "it depends".

From: Andrew Dunstan
Date: 19 April 2021, 16:54:47
Subject: Re: multi-install PostgresNode fails with older postgres versions

From: Tom Lane
Date: 19 April 2021, 17:34:00
Subject: Re: Commit 86dc90056 - Rework planning and execution of UPDATE and DELETE