| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Get PG primary version without substring manipulation? |
| Date: | 2024-06-13 12:52:18 |
| Message-ID: | CANzqJaCSdXU3a4PZzG5cmR9t0qvpL2Wf+EAYL2b1kUO_GXMjtw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
cut, awk, head, bash, etc are easy enough, but am I overlooking some
intrinsic method of getting just PG's primary version number (9.6 or 14, in
my case) without doing substring manipulation?
$ ssh foo.example.com pg_config --version
PostgreSQL 9.6.24
$ ssh foo.example.com psql --version
psql (PostgreSQL) 9.6.24
$ psql -h foo.example.com -Xtc "SELECT version();"
PostgreSQL 9.6.24 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
20150623 (Red Hat 4.8.5-44), 64-bit
$ ssh bar.example.com pg_config --version
PostgreSQL 14.12
$ ssh bar.example.com psql --version
psql (PostgreSQL) 14.12
$ psql -h bar.example.com -Xtc "SELECT version();"
PostgreSQL 14.12 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0
20210514 (Red Hat 8.5.0-20), 64-bit
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Adlersburg | 2024-06-13 13:17:25 | Re: Get PG primary version without substring manipulation? |
| Previous Message | Laurenz Albe | 2024-06-13 07:15:43 | Re: How to Handle Sequences in Logical Bi-Directional Replication |