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 ) id 1tH77T-003ZfK-70 for pgsql-general@arkaria.postgresql.org; Fri, 29 Nov 2024 19:57:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tH77Q-00AI32-Ey for pgsql-general@arkaria.postgresql.org; Fri, 29 Nov 2024 19:57:37 +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 ) id 1tH77Q-00AI2b-2R for pgsql-general@lists.postgresql.org; Fri, 29 Nov 2024 19:57:37 +0000 Received: from mail-yb1-xb33.google.com ([2607:f8b0:4864:20::b33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tH77N-000COM-Sr for pgsql-general@lists.postgresql.org; Fri, 29 Nov 2024 19:57:36 +0000 Received: by mail-yb1-xb33.google.com with SMTP id 3f1490d57ef6-e2bd7d8aaf8so1984593276.3 for ; Fri, 29 Nov 2024 11:57:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1732910252; x=1733515052; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=0QjKKDWEHx50IKj4vpWGIy+KP2QdTNHfHrE9fgxoFsU=; b=GVQnMaEp/sRyVDxqbCrcmFauPSyNgV+juVTLb7J6DpDQruwMqSWeH9L8mX7d28W7xm uuR7nU8972E+/2KMhE9mfpfpCjBrJolvMBRvAmJ8a0oXwRpP5cVGLX02sHn2je6a5dB4 NWN5jYRrzUH/VD3gDKot/bmWVxbite3v2bsMHa/0GNcIY31gpWcXpAAmQCPfLMnND5F3 VyhQCj7GUc0aFpFdqBcMh71JP+1N9IwdOqzYTod4YfhJwNi/v2ayOdY/qjMbqK2hTulQ MMlCbYYAiLZTMTFdFEe+UnN2SmLKGKwLBtNk5ZYMSNgFdCVc7ztsiuo7rWHuVZfBmLRv vGDg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1732910252; x=1733515052; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=0QjKKDWEHx50IKj4vpWGIy+KP2QdTNHfHrE9fgxoFsU=; b=pLiKPLeq/soY+ProbiyVFDrpZ2jX3RPwwCgndCXhixkmfRNB7d1FPJIOaXOAegYX9G V+HkDl5ABmHnn/Ny2UsrxGbDDYrIrZJEhrExIRzjbiQbgQUORzgaCqZaq9nTBS7ImXg2 Yj6AqaEw08vMx+DRqsMmchlxSyXQ396CPA455Ry4D8J08HKwsvIjUPcPSBWploC0VCUf zu+SczpKXzgPcl/nqqxJ7iXtHAJqYcY5GkzCksiwAK0WeSsEX0qnie74Uw5o7vMRVrtm hECOgwtAw9zBN2fPuspuukiZ1aQsSaK2Hu0nOhRGeTR0vL79bDTO8wXrBdmo/onfbB3u OpMw== X-Gm-Message-State: AOJu0YxcQbhCIukLANU7OuHhlTc6ysAeVY6sSZQC+QLIV1UKzLgbVUBi 1zHD89jY6OEZojUhnYRr7qTwMLWFX98fG0KsOwRIy4uUGzcygpNifr5JtJc1FJNBW0qOoMq5FHL PtrtIlwR+6NrRN9+rKpxW5mlTQbM= X-Gm-Gg: ASbGncs6cIQmw5fKaEhjG945/rS2JunMhU7wWXYEgRGjwBUKS4y3A8XiHxJHcBYQvym haQgNbk5eAdh9vq2hQscoNyWJNF6zkWX4NkTsIF5fBKQSjxCvIfXKRN+HG9mJ7mL4sQ== X-Google-Smtp-Source: AGHT+IE8SQkV3PUqlDW/CujBIZeZMU0X6QmeR/At5St+QZ5JaANz7Yzed7W8h9mMS2fIuSPY1d9YtJQBkUl9GESpaIE= X-Received: by 2002:a05:6902:1006:b0:e38:8263:7990 with SMTP id 3f1490d57ef6-e395b961b65mr14378837276.48.1732910252406; Fri, 29 Nov 2024 11:57:32 -0800 (PST) MIME-Version: 1.0 References: <04031b39-c06a-4dc0-b354-1472dc0d39e2@aklaver.com> In-Reply-To: From: Igor Korot Date: Fri, 29 Nov 2024 13:57:21 -0600 Message-ID: Subject: Re: Find out the version of the server To: Adrian Klaver Cc: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="00000000000005c0450628129cf9" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000005c0450628129cf9 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, Adrian, On Fri, Nov 29, 2024, 1:24=E2=80=AFPM Adrian Klaver wrote: > Reply to list also > > Ccing list > > On 11/29/24 11:15 AM, Igor Korot wrote: > > Hi, Adrian, > > > > On Fri, Nov 29, 2024 at 10:12=E2=80=AFAM Adrian Klaver > > wrote: > >> > > >> Reuse it for what? > > > > For building.. > > I got a linking errors of not finding sscanf() and sprntf() > > when building my code. > > > > Googling revealed that MSVC made those inline after > > MSVC 2010. > > > >> > >>> > >>> Is it possible to find what version of the server was used for the > build? > >>> > >>> Im looking at the Windows Explorer timestamp, which gives me 4 > September > >>> 2017. > >> > >> At any point in time there are 5 supported versions of Postgres in pla= y. > >> Given that you could have also built against one of the unsupported > >> versions a file timestamp will not help much. Though if you want to > >> guess, version 10 was released October 5, 2017. It is plausible you > >> built against a RC version in advance of the production release. > > > > Understood. > > I also tried to open the explorer and go to Properties of the DLL built > > > > That dialog shows for src/interfaces/libpq/Release/ for the Detail tab > > > > Type: Application Extension > > File Version: 9.6.2.17037 > > Product name: PostgreSQL > > Product version: 9.6.2 > > > > Can this info be trusted? > >> > >> libpq is backwards compatible, so why not try building against a curre= nt > >> version of Postgres and see whats happens? > > > > Are you saying that the current version can connect even to 9.6.1 > > server? (I have a really old Mac with the 9.6.1 version installed). > > Yes. > > The CLI client psql is based on libpq and from here: > > https://www.postgresql.org/docs/current/app-psql.html > > "If you want to use psql to connect to several servers of different > major versions, it is recommended that you use the newest version of > psql. Alternatively, you can keep around a copy of psql from each major > version and be sure to use the version that matches the respective > server. But in practice, this additional complication should not be > necessary." > > If you have a new version of psql available connect to the 9.6.1 > instance to verify. > Thank you. Ill try to get the new version and build it. > > > > Thank you. > > > >> > >>> > >>> Thank you. > >>> > >>> P.s. please forgive for any typos as it's been written from the Andro= id > >>> phone. > >>> > >> > >> -- > >> Adrian Klaver > >> adrian.klaver@aklaver.com > >> > > -- > Adrian Klaver > adrian.klaver@aklaver.com > --00000000000005c0450628129cf9 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi, Adrian,

On Fri, Nov 29, 2024, 1:24=E2=80=AFPM Adria= n Klaver <adrian.klaver@akl= aver.com> wrote:
Reply to li= st also

Ccing list

On 11/29/24 11:15 AM, Igor Korot wrote:
> Hi, Adrian,
>
> On Fri, Nov 29, 2024 at 10:12=E2=80=AFAM Adrian Klaver
> <adrian.klaver@aklaver.com> wrote:
>>

>> Reuse it for what?
>
> For building..
> I got a linking errors of not finding sscanf() and sprntf()
> when building my code.
>
> Googling revealed that MSVC made those inline after
> MSVC 2010.
>
>>
>>>
>>> Is it possible to find what version of the server was used for= the build?
>>>
>>> Im looking at the Windows Explorer timestamp, which gives me 4= September
>>> 2017.
>>
>> At any point in time there are 5 supported versions of Postgres in= play.
>> Given that you could have also built against one of the unsupporte= d
>> versions a file timestamp will not help much. Though if you want t= o
>> guess, version 10 was released October 5, 2017. It is plausible yo= u
>> built against a RC version in advance of the production release. >
> Understood.
> I also tried to open the explorer and go to Properties of the DLL buil= t
>
> That dialog shows for src/interfaces/libpq/Release/ for the Detail tab=
>
> Type:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Application Extension > File Version: 9.6.2.17037
> Product name: PostgreSQL
> Product version: 9.6.2
>
> Can this info be trusted?
>>
>> libpq is backwards compatible, so why not try building against a c= urrent
>> version of Postgres and see whats happens?
>
> Are you saying that the current version can connect even to 9.6.1
> server? (I have a really old Mac with the 9.6.1 version installed).
Yes.

The CLI client psql is based on libpq and from here:

https://www.postgresql.org/docs/curr= ent/app-psql.html

"If you want to use psql to connect to several servers of different major versions, it is recommended that you use the newest version of
psql. Alternatively, you can keep around a copy of psql from each major version and be sure to use the version that matches the respective
server. But in practice, this additional complication should not be
necessary."

If you have a new version of psql available connect to the 9.6.1
instance to verify.

Thank you.

Ill try to get the new version and build it.
<= br>


>
> Thank you.
>
>>
>>>
>>> Thank you.
>>>
>>> P.s. please forgive for any typos as it's been written fro= m the Android
>>> phone.
>>>
>>
>> --
>> Adrian Klaver
>> adrian.klaver@aklaver.com
>>

--
Adrian Klaver
adrian.klaver@aklaver.com
--00000000000005c0450628129cf9--