Find the location of Postgres data directory

Sudhakar Rayavaram
Jun 1, 2019 · 1 min read

In Postgres, it is not easy to find the location of the data folder because it can be overridden in multiple configuration files and also can be passed as a parameter when starting postgres server

However, there is an easy way to find it out from postgres interactive terminal by running the following command

show data_directory;

data_directory
— — — — — — — — — —
/var/lib/pgsql95/data
(1 row)

TarkaLabs TIL

Tarka Labs is a team of passionate hackers, designers and…

TarkaLabs TIL

Tarka Labs is a team of passionate hackers, designers and product managers. We believe in experimental methods to identify the best solutions to problems instead of working on technology du jour. (https://tarkalabs.com/)

Sudhakar Rayavaram

Written by

[su-docker] Software plumber, health and wellness enthusiast, digital artist, data visualization lover & …

TarkaLabs TIL

Tarka Labs is a team of passionate hackers, designers and product managers. We believe in experimental methods to identify the best solutions to problems instead of working on technology du jour. (https://tarkalabs.com/)

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store