PGCon2014 - Final Release
PGCon 2014
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Stephen Frost |
| Schedule | |
|---|---|
| Day | Tutorials - Day 1 - Tue May 20 - 2014-05-20 |
| Room | Montpetit 201 |
| Start time | 13:00 |
| Duration | 03:00 |
| Info | |
| 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.