Enjoy the newly minted printable schedule available for UTOSC 2009
Miller Free Enterprise Center (MFEC)
Sandy, Utah
Sponsors
Diamond
Sapphire
Emerald
General
Media
Publishers
An Introduction to Postgres Administration
Start: Oct 10, 6:00 p.m.
End: Oct 10, 7:00 p.m.
Location: 123
(map)
Presentation Download(s)
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, and 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.
About the presenter
Spencer Christensen
(Backcountry.com)
I work all day (and some nights too) for Backcountry.com doing all sorts of system administration tasks. I'm the Software Infrastructure team leader, which means that I work with really talented coworkers that do system administration, database administration, network and storage stuff, and of course software administration. I'd say I've been doing sys admin work for about 3-4 years now, and before that I primarily did web development with perl.
