Skip to content

Issue when I tried to perform a data collection with psql 10 #65

@brenobaima

Description

@brenobaima

Hi,

Reading the docs, I could see the postgresql 10 is supported.

However, I'm having an issue when I tried to perform a data collection from a PostgreSQL server with psql 10.

root@node0:/pg_gather# git log -n 1
commit d22e8a2dadc8dddd3bfa4b3b0bfcee9f5f4fdc8c (HEAD -> main, origin/main, origin/HEAD)
Author: Jobin Augustine <jobinau@gmail.com>
Date:   Mon Mar 2 11:38:44 2026 +0530

    Updated the versio compatibility
root@node0:/pg_gather# /usr/lib/postgresql/10/bin/psql -X -f gather.sql > out.tsv
psql:gather.sql:41: unrecognized value ":{?ERROR}" for "\if expression": Boolean expected
psql:gather.sql:49: ERROR:  ***** FATAL : MINIMUM PSQL VERSION 11 IS EXPECTED : PLEASE VERIFY : psql --version ********
CONTEXT:  PL/pgSQL function inline_code_block line 1 at RAISE
root@node0:/pg_gather# /usr/lib/postgresql/11/bin/psql -X -f gather.sql > out.tsv
root@node0:/pg_gather# 

psql installed package postgresql-client-10 from pgdg.
SO used for test: Ubuntu 24

Please let me know if you need more info.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions