Learning PostgreSQLJuba, S., Vannahme, A., & Volkov, A. (2015). Learning PostgreSQL: Create, develop, and manage relational databases in real-world applications using PostgreSQL. Packt Publishing.
Read Chapter 8: PostgreSQL Security.
This chapter will provide you the basics of RDBMS security with regards to authentication, authorization, roles, etc.