PostgreSQL #4 - Physical Layer - Files
PostgreSQL #4 - Physical Layer - Files In the last post in the blog I described most of PostgreSQL`s architecture. If you didnt read that post I suggest you to do it in order to help you better understand the things that I'm going to describe in this post and in the next posts. In the title of the post I mentioned "Physical Layer". One might ask - what does it mean ? In this post I'm going to talk about PostgreSQL`s file system layer. I'm going to explain the importance and the meaning of the directories and the files that were created during the installation (check it out in the second post in the blog). I'm going to focus mainly on the data directory - pg_hba.conf,postgresql.conf, pg_xlog,base,pg_tblspc. Installation directory When you installed PostgreSQL you had the option to choose where to install it. If you installed it via yum or you didnt manualy choose the installation directory it is likely that it was instal...