Francis T. O'Donovan

Data Scientist – Planet discoverer, researcher, developer, geek.

less than 1 minute read

Where does postgres store all of the data for a database cluster? Well, in its data directory. Where exactly that data directory is can depend on how the database cluster was setup. Postgres can tell you right where to look, though. Within psql, run

> show data_directory

Postgres will output the absolute path of the data directory.

Via jbranchaud/til.

Leave a comment

You may also enjoy

Using Stoicism to thrive as an IC Data Scientist

6 minute read

For Data Scientists facing lack of control over data and outcomes, Stoicism offers a framework to thrive in one’s career. By focusing on the “Dichotomy of Co...

Culture turns strategy into action

2 minute read

Like many people, I enjoy working at startups with a mission I believe in. These companies match talented individuals with the latest technologies to solve i...

Python: How uv got so fast

less than 1 minute read

I love uv, the latest python dependencies manager, and use it whenever I can.

Stoicism and the pursuit of a good life

2 minute read

Stoicism emphasizes focusing on the controllable aspects of our lives and accepting the uncontrollable. Applying this philosophy can help us in our pursuit o...