Determine cluster directory from Postgres service

Question

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?

Milen A. Radev · Accepted Answer · 2009-02-20 13:34:49Z

12

(For completeness) And even shorter:

SHOW data_directory;

answered Feb 20, 2009 at 13:34

Milen A. Radev

63.1k22 gold badges111 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Quassnoi · Accepted Answer · 2009-02-20 11:25:41Z

3

SELECT setting FROM pg_settings WHERE name = 'data_directory'

answered Feb 20, 2009 at 11:25

Quassnoi

427k94 gold badges628 silver badges623 bronze badges

Collectives™ on Stack Overflow

Determine cluster directory from Postgres service

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related