public inbox for [email protected]
help / color / mirror / Atom feedFrom: Igor Korot <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Find out the version of the server
Date: Fri, 29 Nov 2024 13:57:21 -0600
Message-ID: <CA+FnnTwgrn1UR5ZpOpDk=WVkZ_yRwdSCsw0w6aCBaNwF1BOpKw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CA+FnnTz+K5VcrQDiNVi=griDkGpnBE2Dnin6ocyA4y4VG+L4+A@mail.gmail.com>
<[email protected]>
<CA+FnnTxTpX4osBonKuGvcFhOQS66fNsoNa_1kObimX2MtQ22jA@mail.gmail.com>
<[email protected]>
Hi, Adrian,
On Fri, Nov 29, 2024, 1:24 PM Adrian Klaver <[email protected]>
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 AM Adrian Klaver
> > <[email protected]> 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 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 current
> >> 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 Android
> >>> phone.
> >>>
> >>
> >> --
> >> Adrian Klaver
> >> [email protected]
> >>
>
> --
> Adrian Klaver
> [email protected]
>
view thread (6+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Find out the version of the server
In-Reply-To: <CA+FnnTwgrn1UR5ZpOpDk=WVkZ_yRwdSCsw0w6aCBaNwF1BOpKw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox