PostgreSQL DB directory structure
Linux installation location - /usr/local/pgsql or /var/lib/pgsql
Windows installation location - C:\Program files\postgresql\ Version_number
What folder present after version number --
Bin folder - contain all the PostgreSQL DB utility
Data folder - Contains all the details related to data
Debug_symbol - for tracing and debugging and use by developer
Doc - Document related
Include folder - Using to function of PostgreSQL
Installer folder - Server installation and pre checks.
Lib - to run postgresql normally, contains DLL files.
pgadmin4 - GUI to work on Postgresql
scripts - all important executable file present here.
share - Contain sample files to rebuild configuration.
What is present in Data Dir -
base - contain info related to database
global - contain info related to global tables
log - all logging information
pg_commit_ts -
pg_logical -
pg_multixact -
pg_notify-
pg_replslot -
pg_serial
pg_snapshots
pg_stat
pg_stat_tmp
pg_subtrans
pg_tblspc
pg_twophase
pg_wal
pg_xact
Comments
Post a Comment