Skip to content

RootDBA

DBA expertise: PostgreSQL, SQL Server & MySQL

Menu
  • Home
  • blog
  • PostgreSql
  • MySql
  • Sql Server
  • About AHMED – Root DBA
Menu

PostgreSQL Directory layout

Posted on September 1, 2025September 1, 2025 by AHMED

${toc}

installation directory layout

PostgreSQL is typicality installed to /usr/lib/postgresql/
the same directory structure is the same both on windows and Linux.,
now we will discussed the content of installation 

bin folder

here you will find all PostgreSQL utility files such as initdb a& bg_ctl
defa50cc102578b8e4efd714d32c82e5.png

data

the folder is located in default cluster and might change depend on if there multilabel cluster created , but by default its located in /var/lib/postgresql/13/main

here you will find all data related to database and the configuration file for the cluster 

log folder

the log of the PostgreSQL is very important it can support you to troubleshoot the status of PostgreSQL 

the log are typically stored in below path
/var/log/postgresql/

0
Visited 9 times, 1 visit(s) today
Category: PostgreSql, Postgresql Dba Guide

Post navigation

← database cluster in PostgreSql
Postgresql configuration files →
© 2025 RootDBA | Powered by Minimalist Blog WordPress Theme