Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1sPnxw-006OZv-QV
	for pgsql-admin@arkaria.postgresql.org; Fri, 05 Jul 2024 18:47:28 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1sPnxu-00D2v4-OY
	for pgsql-admin@arkaria.postgresql.org; Fri, 05 Jul 2024 18:47:27 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <holger@jakobs.com>)
	id 1sPnxu-00D2uw-D8
	for pgsql-admin@lists.postgresql.org; Fri, 05 Jul 2024 18:47:27 +0000
Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de)
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <holger@jakobs.com>)
	id 1sPnxs-000b8x-JQ
	for pgsql-admin@lists.postgresql.org; Fri, 05 Jul 2024 18:47:26 +0000
Received: from localhost (localhost [127.0.0.1])
	by rs.plausibolo.de (Postfix) with ESMTP id B0D04380618;
	Fri,  5 Jul 2024 20:47:23 +0200 (CEST)
Received: from rs.plausibolo.de ([IPv6:::1])
	by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024)
	with ESMTP id xSpEoifDVWtT; Fri,  5 Jul 2024 20:47:23 +0200 (CEST)
Received: from [192.168.147.168]
 (dynamic-176-007-150-253.176.7.pool.telefonica.de [176.7.150.253])
	by rs.plausibolo.de (Postfix) with ESMTPSA id 1F88E380371;
	Fri,  5 Jul 2024 20:47:23 +0200 (CEST)
Content-Type: multipart/alternative;
 boundary="------------Vkz4JUb848nUKrdCNsTOcVV0"
Message-ID: <5e8626de-f7df-45c3-9985-f3cb6ec4e7ea@jakobs.com>
Date: Fri, 5 Jul 2024 20:47:22 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: psql on Windows systems
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@lists.postgresql.org
References: <c7ac2c4e-b3c8-4b36-b5ac-bf401dc255e5@jakobs.com>
 <326176.1720203825@sss.pgh.pa.us>
From: Holger Jakobs <holger@jakobs.com>
In-Reply-To: <326176.1720203825@sss.pgh.pa.us>
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/5e8626de-f7df-45c3-9985-f3cb6ec4e7ea%40jakobs.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------Vkz4JUb848nUKrdCNsTOcVV0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Am 05.07.24 um 20:23 schrieb Tom Lane:
> 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.
> Yeah, readline doesn't exist for Windows last I heard.  At least,
> we don't try to build with it there.
>
> 			regards, tom lane

The page https://tiswww.cwru.edu/php/chet/readline/rltop.html says:
"Microsoft offers its Windows Subsystem for Linux (WSL) 
<https://msdn.microsoft.com/en-us/commandline/wsl/about> 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.

The license of the Gnu readline library shouldn't impose any problem, as 
other BSD/MIT-licensed software, like Tcl (https://tcl-lang.org) also 
uses it.

Kind Regards,
Holger

-- 

Holger Jakobs, Bergisch Gladbach

--------------Vkz4JUb848nUKrdCNsTOcVV0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">Am 05.07.24 um 20:23 schrieb Tom Lane:<br>
    </div>
    <blockquote type="cite" cite="mid:326176.1720203825@sss.pgh.pa.us">
      <pre class="moz-quote-pre" wrap="">Holger Jakobs <a class="moz-txt-link-rfc2396E" href="mailto:holger@jakobs.com">&lt;holger@jakobs.com&gt;</a> writes:
</pre>
      <blockquote type="cite">
        <pre class="moz-quote-pre" wrap="">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.
</pre>
      </blockquote>
      <pre class="moz-quote-pre" wrap="">
Yeah, readline doesn't exist for Windows last I heard.  At least,
we don't try to build with it there.

			regards, tom lane
</pre>
    </blockquote>
    <div class="moz-signature"><br>
    </div>
    <div class="moz-signature">The page
      <a class="moz-txt-link-freetext" href="https://tiswww.cwru.edu/php/chet/readline/rltop.html">https://tiswww.cwru.edu/php/chet/readline/rltop.html</a> says:</div>
    <div class="moz-signature">"Microsoft offers its
      <a href="https://msdn.microsoft.com/en-us/commandline/wsl/about">Windows
        Subsystem for Linux (WSL)</a>
      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. <br>
    </div>
    <div class="moz-signature"><br>
    </div>
    <div class="moz-signature">The license of the Gnu readline library
      shouldn't impose any problem, as other BSD/MIT-licensed software,
      like Tcl (<a class="moz-txt-link-freetext" href="https://tcl-lang.org">https://tcl-lang.org</a>) also uses it.</div>
    <div class="moz-signature"><br>
    </div>
    <div class="moz-signature">Kind Regards,</div>
    <div class="moz-signature">Holger<br>
    </div>
    <div class="moz-signature"><br>
    </div>
    <div class="moz-signature">-- <br>
      <p>Holger Jakobs, Bergisch Gladbach</p>
    </div>
  </body>
</html>

--------------Vkz4JUb848nUKrdCNsTOcVV0--