On 27/12/2009 2:12 PM, Rob Jaeger wrote:
I don't quite follow Greg Smith's reply of 'try guess based on "which postmaster"' (can you clarify?)
He's talking about UNIX systems. This will not help you.
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)
It looks like it's present on all platforms. There are the contents for my Debian (Linux) system:
/usr/lib/postgresql/8.4/bin/postgres "-D" "/var/lib/postgresql/8.4/main" "-c" "config_file=/etc/postgresql/8.4/main/postgresql.conf"
The release notes say that postmaster.opts was added in 7.0, so it'll be present for any version remotely new enough to still be in reasonable use.
-- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
