PostgreSQL architecture

PostgreSQL is probably the most advanced database in the open source relational database market. It was first released in 1989, and since then, there have been a lot of enhancements, it is the fourth most used database at the time of writing.
PostgreSQL evolved from the Ingres project at the University of California, Berkeley. In 1982, the leader of the Ingres team, Michael Stonebraker, left Berkeley to make a proprietary version of Ingres. He returned to Berkeley in 1985, and began a post-Ingres project to address the problems with contemporary database systems that had become increasingly clear during the early 1980s. He won the Turing Award in 2014 for these and other projects, and techniques pioneered in them.

Roadmap to become Postgres DBA

The intent of this guide is to give you an idea about the DBA landscape and to help guide your learning if you are confused. The roadmap is highly opinionated — neither, knowing everything listed in the roadmap, nor the order of items given in the roadmap is required to be followed in order to be a DBA.

Learn basic RDBMS terms and concepts

Get basic understanding of Postgres key terms and basic RDBMS concepts.

• Object model: data types, columns, rows, tables, schemas, databases, queries.
• Relational model: domains, attributes, tuples, relations, constraints, NULL.
• Databases high-level concepts: ACID, MVCC, transactions, write-ahead log, query processing.
• Links:
  • Postgres Glossary
  • SQL and Relational Theory – Christopher J. Date, 2009
  • Database Design and Relational Theory – Christopher J. Date, 2012

PostgreSQL installation on Windows

PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.
PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying. PostgreSQL is a highly stable database backed by more than 20 years of development by the open-source community. PostgreSQL is used as a primary database for many web applications as well as mobile and analytics applications.

I will be showing installation of PostgreSQL on windows.
Following the steps will help you in the installation which is a very straight forward and easy.