In this post, I am sharing the basic purpose of pg_log, pg_clog and pg_xlog log directories in PostgreSQL. If you look into your PostgreSQL data directory, you can find a different type of log folders. pg_log: This is a default database logs like: error messages, executed query log, dead lock information, Postgers start/stop messages. First, […]

I'm Anvesh Patel, a Database Engineer certified by Oracle and IBM. I'm working as a Database Architect, Database Optimizer, Database Administrator, Database Developer. Providing the best articles and solutions for different problems in the best manner through my blogs is my passion. I have more than six years of experience with various RDBMS products like MSSQL Server, PostgreSQL, MySQL, Greenplum and currently learning and doing research on BIGData and NoSQL technology. -- Hyderabad, India.