Re: Finding the bin path

[Rob Jaeger <yogirob@xxxxxxxxx>]

I was not clear in my initial question. I need to access the pg_dump.exe and pg_restore.exe files from within a c++ program. I can't execute pg_config.exe because it's in that bin that I'm seeking.

I don't quite follow Greg Smith's reply of 'try guess based on "which postmaster"' (can you clarify?)

But - I think I have found what I need! I can do a "SHOW data_directory;" and then from there I can snoop inside the postmaster.opts file to get the bin path. The question I have now is - is this method safe? Is this file present in all platform data directories. (I'm using Win7)

Thanks to everyone who replied. I really do appreciate this community. - Rob

On Sat, Dec 26, 2009 at 5:54 PM, Greg Smith <greg@xxxxxxxxxxxxxxx> wrote:

Tom Lane wrote:

Rob Jaeger <yogirob@xxxxxxxxx> writes:
  

Is there a command or reliable method of finding the location of the
PostgreSQL bin path?