Postgres Pro
Downloads
Home   >   mailing lists

Re: Discovering postgres binary directory location - Mailing list pgsql-general

From Paul Förster
Subject Re: Discovering postgres binary directory location
Date
Msg-id 8FA9B2DC-2DFB-4A6D-A470-E8A16D0EDD73@gmail.com
Whole thread Raw
In response to Re: Discovering postgres binary directory location  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Discovering postgres binary directory location
List pgsql-general
Tree view 
Hi Raul, hi Adrian,

> On 11. Nov, 2020, at 23:26, Adrian Klaver <adrian.klaver@aklaver.com> 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

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Need to place pgpool logs on separate directory
Next
From: Saurav Sarkar
Date:
Subject: Re: Encryption with customer provided key in a multi tenant Postgres JSONB DB