PostgreSQL (System) Administration

We'll cover the basics of PostgreSQL administration, including defining what 'cluster', 'database', 'schema' and 'tablespace' mean in PostgreSQL, when to use which, how to authenticate to PostgreSQL as a unix user or over a network, what enterprise authentication systems PostgreSQL can integrate with, setting up new users and groups (also know as roles) in PostgreSQL, how to control access to PostgreSQL objects (including setting up default permissions for certain types of objects), addressing storage needs as your database grows by using tablespaces and a crash-course of how to tune PostgreSQL in a few minutes for your brand new database server.