Message-ID: <68e53a89-bafb-4a3f-a2ce-be537a8285a4@jakobs.com>
Date: Mon, 8 Jul 2024 08:03:05 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: psql on Windows systems
To: pgsql-admin@lists.postgresql.org
References: <c7ac2c4e-b3c8-4b36-b5ac-bf401dc255e5@jakobs.com>
 <326176.1720203825@sss.pgh.pa.us>
 <5e8626de-f7df-45c3-9985-f3cb6ec4e7ea@jakobs.com>
 <143e628cad21b4f48b6d0e5f539ebe384899548d.camel@cybertec.at>
From: Holger Jakobs <holger@jakobs.com>
In-Reply-To: <143e628cad21b4f48b6d0e5f539ebe384899548d.camel@cybertec.at>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/68e53a89-bafb-4a3f-a2ce-be537a8285a4%40jakobs.com>
Precedence: bulk


Am 06.07.24 um 07:51 schrieb Laurenz Albe:
> On Fri, 2024-07-05 at 20:47 +0200, Holger Jakobs wrote:
>>> Holger Jakobs <holger@jakobs.com> writes:
>>>> Recently I had to use PostgreSQL on a Windows based system, and I was
>>>> surprised that the psql tool behaves differently, when it comes to the
>>>> functionality of the readline library.
>> The page https://tiswww.cwru.edu/php/chet/readline/rltop.html says:
>>
>> "Microsoft offers its Windows Subsystem for Linux (WSL) as an installable add-on
>> for Windows 10 and Windows 11. It's basically a separate packaged version of
>> the Linux kernel that runs as a Windows service, and you can build and install
>> readline-8.2 within that environment." Maybe it works when the machine doing
>> the compiling and packaging has WSL installed. Would be worth trying, imho.
> Yes, it should be simple to build "psql" with readline in that environment, so
> I recommend that you do that.
>
> I guess the Windows binaries don't want to require the users to install
> Microsoft's Linux emulation.  After all, if you do that, you might as well
> use the ready-made Linux binaries.
>
> Yours,
> Laurenz Albe
>
I think that it would be possible to statically link any libraries which 
aren't available on a standard Windows installation lacking WSL.

Of course, forcing WSL on all Windows users is a no-go.

Maybe this link helps with that:
https://stackoverflow.com/questions/4737082/statically-linked-correctly-working-readline-library-under-windows

Kind Regards,

Holger

-- 

Holger Jakobs, Bergisch Gladbach