PGCon2014 - Final Release

PGCon 2014
The PostgreSQL Conference

Stephen Frost
Day Tutorials - Day 1 - Tue May 20 - 2014-05-20
Room Montpetit 201
Start time 13:00
Duration 03:00
ID 734
Event type Workshop
Track Tutorial
Language used for presentation English

PostgreSQL (System) Administration

So you have a new app to deploy (or a developer developing one)- and so you need a database. Come and learn how to get PostgreSQL up and running, the terminology, basics of user management (aka authN) and how PostgreSQL can tie into external authentication systems, the permissions system (aka authZ), managing space usage with tablespaces, and simple tuning techniques. Basically, all you need to get that database system up and running and humming along smoothly for your application or developer needs.

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.