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 1t149D-00EZ39-7c for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Oct 2024 13:33:07 +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 1t148B-003Nw2-Fp for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Oct 2024 13:32:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t148A-003Nt1-SS for pgsql-hackers@lists.postgresql.org; Wed, 16 Oct 2024 13:32:03 +0000 Received: from mail-yb1-xb35.google.com ([2607:f8b0:4864:20::b35]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t1488-001BbP-Cm for pgsql-hackers@postgresql.org; Wed, 16 Oct 2024 13:32:02 +0000 Received: by mail-yb1-xb35.google.com with SMTP id 3f1490d57ef6-e2915f00c12so5300942276.0 for ; Wed, 16 Oct 2024 06:32:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=joeconway.com; s=google; t=1729085519; x=1729690319; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:autocrypt:from :content-language:references:to:subject:user-agent:mime-version:date :message-id:from:to:cc:subject:date:message-id:reply-to; bh=PV70NvzLdE0+JdB4HPq1e7tSw+2+2/1PQOl/m90BqsM=; b=kllOeaVTkcL+fVTAHku19IQHiQ/DcG7BJyPaaSuHdXxCCo80GRhMKHqgUrnlvtLW8+ m7LavCdRvfzDJQOuegAmGeJaUA8WH5uA3vId2OD5f2dp44AewTcnlyBJoOgL0r6LFCsA /8tdNnS76Hz4rzQuKR0pXJ8RCV+Bc1pybqfN96o4/UNWXlr4K1tSf5NqYv2dKmEWZl6x 7hSPjwGb2LYbOR4OAoCKLr8Q4h0k2/V0IIVJ6TfvZz3nnG2oamcCH3P5I+RLY1nhPZaO TTga74QiL7TgLpMauNnVpMA9u4yexpZmeoOf3yX8qnWk3YNvKSuzhLo32Knbd31G0bWR 2wHA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1729085519; x=1729690319; h=content-transfer-encoding:in-reply-to:autocrypt:from :content-language:references:to:subject:user-agent:mime-version:date :message-id:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=PV70NvzLdE0+JdB4HPq1e7tSw+2+2/1PQOl/m90BqsM=; b=wnFwad+RKb1MYBA/LY07kaHZcG334wivX4pntiv0xZpUy4Ah8qwqOG5qSS74ETeLsp vlp9bkmLyU294gbyf39soE3t9787lOeHF4TT/SHwQpFIwCLaV/aucjYISqgdYZ0W+UD/ TV5D/5TY/Urx7c9UB2rGHjrYcgPM8ozHNhHQI29NBqyHrE4/uq2GrEtDPo1aElgS6m70 djtbD8FT/6GUae29wqsoSuVtNbT4W8nFHp3B6SUTfoTutFiH0+/9LdqxkHpFJtFzATgt XDLvy4JWfezjmSfmnW04FzgGzWbCZsY2xrvlB5/cyH8ioJx9dQqN0BJUe4pYgcDl0V5d gZwg== X-Forwarded-Encrypted: i=1; AJvYcCWZk1taLdFUJn0Hw5wRFWr/Wyd8ovSjWe+DLPYBwKs15t1KEIut11BQ8UuZUqjKygYIo5qSnF/Zgdvg0PR/@postgresql.org X-Gm-Message-State: AOJu0Yw3kFKdYKvWnKVV8GlgjoxaHhBCBrz2GGBRgzFeJZCH/1hw+2jf j2s8A5k/qiqRLhq8MGZlOHZKH6P7hssFWRiJ7kd2lRhsQKWmX9UP4yF8+7L/y7E= X-Google-Smtp-Source: AGHT+IHKZTRqBTF3EUKjUz7h24gV2Aqv9COaVjAC/+i1DRAydZjFAzoc7qXJ/EY8hQlSkZ9x0r0vqw== X-Received: by 2002:a05:6902:990:b0:e28:fd71:4acd with SMTP id 3f1490d57ef6-e29782b76c6mr3922371276.2.1729085519477; Wed, 16 Oct 2024 06:31:59 -0700 (PDT) Received: from [192.168.4.41] (162-239-31-113.lightspeed.dybhfl.sbcglobal.net. [162.239.31.113]) by smtp.gmail.com with ESMTPSA id 3f1490d57ef6-e296d050c0esm585720276.49.2024.10.16.06.31.58 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 16 Oct 2024 06:31:59 -0700 (PDT) Message-ID: Date: Wed, 16 Oct 2024 09:31:58 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: System views for versions reporting To: Peter Eisentraut , Dmitry Dolgov <9erthalion6@gmail.com>, pgsql-hackers@postgresql.org References: <588dcd4f-2c3e-4eb4-ad38-e2edc9adf2d3@eisentraut.org> Content-Language: en-US From: Joe Conway Autocrypt: addr=mail@joeconway.com; keydata= xsFNBEpXMCsBEADDnXUQzjlyi/cX02Gtdy2CLcroE5CsC7DJKdOBDbfgn0kfiIYoV5JniG4l VyzZUodY8yUAagqLYolh0UkBzs9N+qkm7erde4ypw3jzVQ37BuzIvk3nMUbuDZDgxWqX+nVS sKc+BQ5BpzgCHg48leoRO2ohjvYnUhgH3j2rFZCzaj6qQ7mv+XoxOJmUlVQtG06Jwkk7Vu14 7U9nMMM6hyUKzVnmCphnlcMNo26UyVU70MwFfFJgcI0c5fpp8byN56eD6VJVnufO5WAuEhzE qcrSJR2FAlmM90GBY+6vP29twLDCHuSFvrnujNCx/BvCC/a3/gPvyAFp4JtMm9eXAmq3m/Kw 94nTJXVdcbQeQQDp3KIG7MmWS4lnGvPn8v0CjgNaLvZXFLo1FgmUVsyEq1Lww4iRLa6sbpXJ ESx15UEue1k1YZM9C+4F/o3aeKNsAienjw2EXFzcaxIg/C4P493VMi3Qa8ycVxR5iYhUbYdo DFIUQhbFNsYfrtW/qZAELT3FCYFpZYG01e9Hj+cBrXXgyDDkQ5Lq4mlvmkRvuxn61V6Au4HA 0sJiCox5pM1FvzT+aI8HY1BYaiB9Pl4fhpKgmhhlSuglk9v39S4jmlUIb45iLAUVpeNM6Qjm 69pf5da9sm4aGFa7YlDSKf/WcU7z9ITZxsilOi2n7YJiwG7kTQARAQABzSRKb3NlcGggRSBD b253YXkgPG1haWxAam9lY29ud2F5LmNvbT7CwXoEEwEIACQCGwMCHgECF4AFCwkIBwMFFQoJ CAsFFgIDAQAFAlWTVvUCGQEACgkQMyt+aLaZQ0oPCQ/9HyRewMyvAIJRmoXoLAr8AoFLId6R qBJnNX0Lll0RLZui65aQ0+exwX7aH7TxWR16B2gWX3OmLfGT8XITOoG+zt9zsEpLvNkHchkF T/jyAcbuRj5WX9hamZgMbjXAJeCdlhW+fRA9Upb0w4dgBjqK5OgsqMikASL7t2vogHl9H08j vSoQLW+8wTnSBXBeBTBwB7xLIin5WVivzFHUCrnD2UsjeBIW3fmGdpTAjSxRzG+UPYVwXQ8F FLt7DpEytvLWapmZWMRdj0WZ/Q3SOO/Ed0yFqbzuwKaWcFrQBNeS2Sig+FefBNS98f9Hx7ku H3DW34qX/zSSdDh0jLs7X3PkIgF6BZR2TxaCwHPP9ERDiDaUInC9U7We1iZE1DjW8rLMEVJB hY0ClrrF67pnUKTbcU+uajpPn+2Jl74T0Set/XxpHZ4cezcJuqg31R8vHZgd5cf1WKP0D0pc qiuS02BBFkNCs1jQ+raTWcDuE6F1mUO2nvjUBN9r4y5DUbCNSqLKeAe/aA6JaSDkBpoXKdNS +c4rbzbktWkfUW8EhVlCGzNpy4ezEoVsqV2Ex7fNoxsE2vnSylLT9hycAmYf8ryMvniRZqnD T4JgLenIcQlkhB896T7wApOXfD8OJj1/XFxAfPi6vdlsr81uoxuB4euLp8IyduwLORRUogO9 zmAXG5jOwU0ESlcyJwEQAOkTBb9yDhJbMUgvhM11rZwT5tm4Y9TqtEHn0Zy3t9g7bdFFpMva v/KENd3oAtLFpMDf+H3AggFk4ftUwJwiVgJ88ilvCynJUGXiuYIaexY4DLgn4xpnuiEpYEFV dWnlw7dWVTc62exfqIz9bSWRzwfBCY9ruYGEb4RDPDSNSAVyI7sxHzef2asiYxIcxrTrw5Vu gWNlPZcV5/EJ6PUvATjBF2TBkXV7KOciQng2tsQGrGMkY5mduNqwpuh6zfPcVF8LeObe96wv 5ZhPRpO79nef7hnK2lJogp3JIo558Jlbz9WHtQEMZR85+bUhtI825QyNAFz3Jrn7NMgvDikc 2OrWo7YMgMC5hDSWVFqA6/EQCNnDWGABWgeYHZFpnPwsvUWIYdhSilUuj/Tuzvz9ZmucFNbQ bauDQw6VQ38ofGnoYDZFJsGncprB8dBi4tDrIQ+1RlIh6C2Z/eMipqJOT26+spluTjouvnKT 0S5yOgyX0PjbsysgwQdCGNJLHOjhHbSpSmOLaduV3CQo/0+DHT/TBjYfIXjTWouY9TkGxG4e NrxU0u2xAy5bMqOPmsFdjLTWlQUlF/fTMhB54XwI3FHWgnSnXZzStDTmTebLNdT/ftgliAzA 81uMj49j0exv731/v+7udLA1bV8gnZ01zQCASDpWiRQR3fgwcugSUqgRABEBAAHCwV8EGAEI AAkFAkpXMicCGwwACgkQMyt+aLaZQ0pwAQ//bjcWnZg/jjRQ9gbZUGMqniItZYRglBMKIqt4 Fia379JmHwTvavnFkJ8XMZ56UB0FIrgS+sUkRH6cPRQR+7Qi392LD021DXgSsz9CwFHjFyBG HwLEOTRcfYQbtJy0shHDJB4aQTOX3ERDH1PsvJNuevmQMzS0DWFav9+xMz9rKP4N+HffoBIZ E0C1xIE43nD4eLsbycte9sVIrmlNuUti3qUxJAQw8HwfJ6ZbBInHxquApR16uD1u99o6Xlnd FrDlY22tRmHCM0bR81GfGNdcU3Uo+rG/R/k4qa7s9/dgKvMbyH3fHhp/ceKag80Xo8IFurRl 0ZJP3sHJ2QDHCVLat7jRZ+43hi1WlIhFbrgn6IyI0i7XR/W8JjrC5MsKq4TUwGH077sU/kcH YebVJZRbUUst2hAGHDFVBcG12qoKf+ltL9qXJc1y7BGeCoUW6QjOpljpq6ZL4FQUsM0RSRjs 5egE3szPcIf5SyPK6WDOApoAq6M7BBFMGDZwEylYMtr0YekA1u86UA9D2xwLHEbBBp/uiby1 c9JbPJ1Pn8zJP8WZNeRw4Q9TtqVK09+oLirMUSpIDd6KdZ1VgRxOK2re7tjDvkVuYsSrsiJ+ 1iJNEnp9iK0ok0DlJpSCe6KhkxpaTdeoWMXdKuJWec0NIqoAd54ZgBPnr+UPxTixgPq/p6Q= In-Reply-To: <588dcd4f-2c3e-4eb4-ad38-e2edc9adf2d3@eisentraut.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 10/16/24 08:47, Peter Eisentraut wrote: > On 06.10.24 17:36, Dmitry Dolgov wrote: >> Based on the feedback in [1], here is my attempt at implementing system >> views for versions reporting. It adds pg_system_versions for showing >> things like core version, compiler, LLVM, etc, and pg_system_libraries >> for showing linked shared objects. > > Is a system view the right interface? For example, in pgbouncer we just > added it to the version output: > > $ pgbouncer --version > PgBouncer 1.18.0 > libevent 2.1.12-stable > adns: c-ares 1.19.0 > tls: OpenSSL 3.3.2 3 Sep 2024 > > That way, you can get this information without having to start a server > instance. (Maybe you can't start a server instance because it just > crashed because of some library version issue ...) While it is also useful to be able to get the info without being able to start the server, I think that would be an addition not a replacement. When you have a fleet with no direct access to run shell commands, being able to get this info via SQL is valuable. -- Joe Conway PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com