Detect bin directory

From: Tiziano Valdemarin <tizianovaldemarin(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Detect bin directory
Date: 2013-11-04 14:22:35
Message-ID: CAHzW5VFnkDKYdBbVVQ7RSB5je3O5u+BZVyr5HtMhbgrVtQ2f+w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-11-04 14:28:55 Re: Detect bin directory
Previous Message Albe Laurenz 2013-11-04 14:08:40 Re: Curious question about physical files to store database