Re: Discovering postgres binary directory location

2020-11-12 Thread Paul Förster
Hi Mark, > On 12. Nov, 2020, at 16:37, Paul Förster wrote: > > how about searching for pg_ctl only inside a bin directory: > > $ find / -type f -name "pg_ctl" -exec grep "/bin/" {} \; 2>/dev/null > Binary file /data/postgres/12.4/bin/pg_ctl matches > Binary file /data/postgres/13.0/bin/pg_ctl

Re: Discovering postgres binary directory location

2020-11-12 Thread Paul Förster
Hi Mark, > On 12. Nov, 2020, at 16:19, Mark Johnson wrote: > > # find / -name pg_ctl > /usr/pgsql-13/bin/pg_ctl > /usr/local/pgsql/bin/pg_ctl > /usr/pgsql-12/bin/pg_ctl > /usr/pgsql-9.6/bin/pg_ctl > /root/Downloads/postgresql-12.1/src/bin/pg_ctl > /root/Downloads/postgresql-12.1/src/bin/pg_ctl/p

Re: Discovering postgres binary directory location

2020-11-12 Thread Mark Johnson
On any given server there could be zero, one, or many PGHOME/bin locations. The OP wants to identify all of them. The default location used by package-based installers is different from the default location of software built from source, and when building from source you can specify a non-default

Re: Discovering postgres binary directory location

2020-11-11 Thread Paul Förster
Hi Raul, hi Adrian, > On 11. Nov, 2020, at 23:26, Adrian Klaver 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/pg

Re: Discovering postgres binary directory location

2020-11-11 Thread Adrian Klaver
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 So what would be the best way to dis

Discovering postgres binary directory location

2020-11-11 Thread Raul Kaubi
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* So what would be the best way to discover this in specific host. Regards Raul