How to locate the data or cluster directory in PostgreSQL

If you used the one-click installer from EnterpriseDB to install a new version of PostgreSQL and left all the settings on their default settings the data directory will be as follows:

1.            On Windows 

1.            c:\Program Files\PostgreSQL\10\data or;

2.            c:\Program Files\PostgreSQL(x86)\10\data

2.            On Linux (CentOS and OpenSuse) /opt/PostgreSQL/10/data

You can however change the data folder while installing PostgreSQL(or even afterwards), which can make it difficult to locate the data directory at a later stage. You can use PostgreSQL's data dictionary to locate the data directory. To do this you need to run the following query from pgAdminIII or psql:

Alternatively you can use: