PostgreSQL Administration for System Administrators

Spencer Christensen

There are many aspects to managing an RDBMS. Some of these are handled by an experienced DBA, but there are a good many things that any sys admin should be able to take care of if they know what to look for.

This presentation will cover basics of managing Postgres, including creating database clusters, overview of configuration, and logging. We will also look at tools to help monitor Postgres and keep an eye on what is going on. Some of the tools we will review are:

* pgtop

* pg_top

* pgfouine

* check_postgres.pl.

Check_postgres.pl is a great tool that can plug into your Nagios or Cacti monitoring systems, giving you even better visibility into your databases.

AttachmentSize
pgconfEast-postgres-for-sysadmins-presentation.odp367.55 KB