Is it possible to determine the cluster directory used by the Postgres server from the server itself - that is, the service (under Windows) is started using the following:
C:\foo\postgres.exe -D "D:\emr\data"
Is there a query or SELECT function that can be executed on the current server to get the value D:\emr\data ?
source share