Sessions at Open Source Bridge 2010 about PostgreSQL

Thursday 3rd June 2010

• Introduction to PostgreSQL

  by Josh Berkus and Christophe Pettus

  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/prod...

  • Databases
  • Land Administration
  • PostgreSQL
  • SQL
  • XML Databases

  At 1:30pm to 2:15pm, Thursday 3rd June

  Coverage note audio clip