Re: Discovering postgres binary directory location

[Paul Förster <paul.foerster@xxxxxxxxx>]

Hi Raul, hi Adrian,

> On 11. Nov, 2020, at 23:26, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
> 
> On 11/11/20 2:22 PM, Raul Kaubi wrote:
>> Hi
>> CentOS 7
>> Postgres 9 to 12
>> I am looking ways to universally discover postgresql binary directory for monitoring purpose.
>> For example postgres 12, it is: */usr/pgsql-12*
> 
> pg_config --bindir
> /usr/local/pgsql12/bin

or by query:

postgres=# select setting from pg_config where name = 'BINDIR';
         setting         
-------------------------
 /data/postgres/12.4/bin
(1 row)

Cheers,
Paul