Data Directory PostgreSQL 9.1 to Windows 2008 Server R2

Question

"My predecessor" has installed PostgreSQL 9.1, now I would like to know what is the "Data Directory" installation.

Now I am using this interface:

enter image description here

Can I know using this interface the Data Directory?

Thanks.

score 2 · Accepted Answer · answered Dec 11 '14 at 13:00

2

start PGAdmin3 , connect server , select Tools -> Server Configuration -> postgresql.conf, and look for data_directory variable

answered Dec 11 '14 at 13:00

simplexio

score 1 · Answer 2 · edited Apr 13 '17 at 12:43

1

As a superuser you could run the query

SHOW data_directory;

edited Apr 13 '17 at 12:43

Community

answered Dec 11 '14 at 12:52

hmallett

2 Answers2