Re: Get version info

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: rob stone <floriparob(at)tpg(dot)com(dot)au>, Igor Korot <ikorot01(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Get version info
Date: 2026-07-05 14:53:04
Message-ID: 31f963d5-4395-4215-96ab-92448283147a@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/5/26 1:18 AM, rob stone wrote:
> On Sun, 2026-07-05 at 01:32 -0500, Igor Korot wrote:
>> Hi, ALL,
>> Google recommends using pg-config.
>>
>> However, some distro prefer to use pkg-config and don't even include
>> local configuration file.
>>
>> Is this file located everywhere and if not - how do I check it inside
>> configure.ac?
>>
>> Thank you.
>>
>
>
> See chapter 9.27.11, not Mr. Google.
>
> select version();
>
> PostgreSQL 18.4 (Debian 18.4-1+b1) on x86_64-pc-linux-gnu, compiled by
> x86_64-linux-gnu-gcc (Debian 15.3.0-1) 15.3.0, 64-bit
> (1 row)

In addition:

show server_version;
server_version
------------------------------------
17.10 (Ubuntu 17.10-1.pgdg24.04+1)

show server_version_num;
server_version_num
--------------------
170010

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2026-07-05 14:56:38 Re: Get version info
Previous Message Laurenz Albe 2026-07-05 13:12:57 Re: last_analyze/last_vacuum in pg_stat_all_tables (PG 17.10)