Detect bin directory - Mailing list pgsql-general

From Tiziano Valdemarin
Subject Detect bin directory
Date
Msg-id CAHzW5VFnkDKYdBbVVQ7RSB5je3O5u+BZVyr5HtMhbgrVtQ2f+w@mail.gmail.com
Whole thread Raw
Responses Re: Detect bin directory
List pgsql-general
Hi, i deploy one windows application which uses pg and since i have hundred of customers i wrote an updater (updates are mainly monthly). The updater manage pg upgrades too through uninstall and reinstall if there are major server updates to do.

This process needs backup and restore and i recently started to do it using pg_dump and pg_restore instead of copyin and copyout.

Since these are windows installation and since i plan to port my app to mac and linux locating these executables is important for me and i'd like a simple way to query pg for its bin path.

I know the data directory path can be found in pg_settings, but what about bin? Is its path stored anywhere? 

I already googled the topic but found only negative answers. Is there any motive to not expose this information as for the data dir?

Thanks in advance
Tiziano

pgsql-general by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: Curious question about physical files to store database
Next
From: Tom Lane
Date:
Subject: Re: Detect bin directory