Is it possible to determine the cluster directory being used by a Postgres server, from the server itself -- i.e. the service, (under Windows) was started by something like:
C:\foo\postgres.exe -D "D:\emr\data"
Is there a SELECT
query or function one can make to the running server to retrieve the value D:\emr\data
?
(For completeness) And even shorter:
SHOW data_directory;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With