PostgreSQL Tutorial for Absolute Beginners [Administration]
About Lesson

The above diagram shows that PostgreSQL architecture consists of 2 main sections. As of now, we leave the discussion of physical files and we discuss about physical files in detail during our physical database layout discussion.

  1. Process Architecture.
  2. Memory Architecture.

Process Architecture: PostgreSQL has the following 4 process types.

  1. Client process
  2. Backend/Server process.
  3. Background processes
  4. Postmaster process.