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 1tH7t8-003i5E-IF for pgsql-general@arkaria.postgresql.org; Fri, 29 Nov 2024 20:46:54 +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 1tH7t5-00Aiv0-Ue for pgsql-general@arkaria.postgresql.org; Fri, 29 Nov 2024 20:46:53 +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 1tH7t5-00Aius-H1 for pgsql-general@lists.postgresql.org; Fri, 29 Nov 2024 20:46:52 +0000 Received: from mail-yb1-xb2a.google.com ([2607:f8b0:4864:20::b2a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tH7t3-000CsD-Rq for pgsql-general@lists.postgresql.org; Fri, 29 Nov 2024 20:46:52 +0000 Received: by mail-yb1-xb2a.google.com with SMTP id 3f1490d57ef6-e396c98af22so1946478276.1 for ; Fri, 29 Nov 2024 12:46:50 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1732913207; x=1733518007; 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=Jm4i/hsPQ9cJuHVdzE9ioO2C4WdF8Q7cUKfx2pMy6+4=; b=TX+fxQmmSMnbbwCj2kECdakG2Rxvw8P/ozfs5NO60pp5Gs2L1vwJ7sCS+AYKQYXysx rePVtGjQ30dVW4CvfCjYKBNntR9VNblcfkwkroS1yblhSnYtxzuTMTANGd0rd/BfiNVX XmTyMyNuqb00pVIIFzpOGC0TvntCyCFUy/Vm01ygQCHtjchgNzmezSzbWkp1X+9IwvPH vQl/g8AqA2ksCl52qNGg8SM1yEb/TkUaFzWOwYps8MQEyBdBLtdFgtFgxj6TrZKhv/k3 67y92Rr7Dyu4/Zj03H5gXvvHhm/c2v6aMmj7P4AV4rG8vz0iFRZ8xPYoj09QhSYplk1a 1txQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1732913207; x=1733518007; 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=Jm4i/hsPQ9cJuHVdzE9ioO2C4WdF8Q7cUKfx2pMy6+4=; b=ljPixwGVBbyRPnJpJSrd2CwKbJu4vMaMqcWM4dLomrVFdQ3Ou2/5taGA4kEKWhyRIb TfqjrxkuTBJxhMzYOIeakc3GaVWVOURy5EokgA6zVd90jHEQdn9nuK9ZBUSIZcusJSGX KlR5tfiFDK1n1uFiTwh8g1I7UNpgl+IDhiHcIJ2iU0XWicuozQntU7XA5s6I+lH3lZ4/ VSwGQy0Y6EpgvaSDnFhQ6+Q5rgTeTcemOhoFG/LHdV4Iptc/SSVY+yJL3uOXLfV+VKGl 6NzXrw8cPNQN3Xm5V7p/LU52JawR7XoEHjis5onoY3b0tlAAN6S1UBuzWBZzTXbtnBEg 14/Q== X-Forwarded-Encrypted: i=1; AJvYcCX2lYH5sHijmdMqp5KNMMZv5nAf+w8Jxd/IQxO5S+/FEHlKMpiO/ee2ZyYzWZgDucmgebu8KIQy4Sznev+O@lists.postgresql.org X-Gm-Message-State: AOJu0YzBOR6s8HOcYncMi5qGf5BwvlAAdRlYGWNG3GGdUKdG4Nn+fKyk z+O4/H3rQz45R0tDnux3TlxXmZ3Bpes0uWhFC06zzYIYEsXYln/xvZEqCElr1cQXYmtOjK78TgN 6UIRoNr1T+2yn58rj2xneXpMlsBo= X-Gm-Gg: ASbGncs9JmgLlKpVTN3VJQPjXpq0Q2JIhY6l7ua3D+T4CLOYxBnRqqOK5zEjZdnCf/F gs8bTk/jSOWPxJHpyZggzUnpQNMS/IEZd0MesJbzkXieFdF4qRJJadH/Ug+ZSqPR3lg== X-Google-Smtp-Source: AGHT+IEg7bwxn4uZHhR8LvwG/JOsN3bcGWFr+08LT4CJ9+PnSCLPftVeyU9NudQ75iKeXp/1BE1Cc8gTpbSSD7M3VKE= X-Received: by 2002:a05:6902:120a:b0:e30:c76e:960d with SMTP id 3f1490d57ef6-e395b8c23a4mr13710662276.27.1732913207676; Fri, 29 Nov 2024 12:46:47 -0800 (PST) MIME-Version: 1.0 References: <04031b39-c06a-4dc0-b354-1472dc0d39e2@aklaver.com> <537496.1732910624@sss.pgh.pa.us> In-Reply-To: <537496.1732910624@sss.pgh.pa.us> From: Igor Korot Date: Fri, 29 Nov 2024 14:46:36 -0600 Message-ID: Subject: Re: Find out the version of the server To: Tom Lane Cc: Adrian Klaver , "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000002b972e0628134c39" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000002b972e0628134c39 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Thx. On Fri, Nov 29, 2024, 2:03=E2=80=AFPM Tom Lane wrote: > Adrian Klaver writes: > > On 11/29/24 11:15 AM, Igor Korot wrote: > >> 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. > > Current libpq will probably work with servers back to around 7.0 > (whenever we introduced the version-3 wire protocol). We don't > routinely test it against anything older than 9.2, but I tried > current psql against 8.2 (the oldest functional server I have > on this machine) and it basically worked. > > regards, tom lane > --0000000000002b972e0628134c39 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thx.


On Fri, Nov 29, 2024, 2:0= 3=E2=80=AFPM Tom Lane <tgl@sss.pgh.= pa.us> wrote:
Adrian Klaver = <adrian.klaver@aklaver.com> writes:
> On 11/29/24 11:15 AM, Igor Korot wrote:
>> Are you saying that the current version can connect even to 9.6.1<= br> >> server? (I have a really old Mac with the 9.6.1 version installed)= .

> Yes.

Current libpq will probably work with servers back to around 7.0
(whenever we introduced the version-3 wire protocol).=C2=A0 We don't routinely test it against anything older than 9.2, but I tried
current psql against 8.2 (the oldest functional server I have
on this machine) and it basically worked.

=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 regards, tom lane
--0000000000002b972e0628134c39--