Introduction to PostgreSQL

*
Accepted Session
Short Form
Scheduled: Thursday, June 3, 2010 from 1:30 – 2:15pm in Broadway

Excerpt

Interested in using PostgreSQL for you next project, or migrating to it? This tutorial will go over the basics of PostgreSQL administration and database application design.

Description

Interested in using PostgreSQL for you next project, or migrating to it? This tutorial will go over the basics of PostgreSQL administration and database application design, including coverage of the features available in version 9.0.

Topics to be covered include:

  • Installation & packaging options
  • Basic performance configuration
  • Basic security configuration
  • Creating your first database
  • Backups, PITR and Replication
  • Common administrative tasks
  • Application design patterns
  • Managing database changes over time
  • Special features you might not know about
  • Tools you’re likely to need

In order to get the most out of this tutorial, all users should bring a laptop with PostgreSQL Version 8.4 and pgAdmin installed. For users unfamiliar with installing PostgreSQL, the One-Click installer is here: http://www.enterprisedb.com/products/postgres_plus/download.do

Speaking experience

Speakers