Open Source Bridge

Excerpt

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

Tags

SQL, database, PostgreSQL, Administration

Speaking experience

Speakers

• 

  Josh Berkus

  PostgreSQL Project
  • Website: http://www.pgexperts.com/
  • Blog: http://it.toolbox.com/blogs/database-soup
  • Twitter: fuzzychef

  Biography

  Josh Berkus is best known as a Core Team member of the world-spanning PostgreSQL project. He is CEO of PostgreSQL Experts, Inc. and in his 12 years as a database consultant he has worked with CouchDB, MySQL, Oracle, and MSSQL Server as well as Postgres, and is heavily involved in many OSS communities, including BIRT, OSCON, OSfA, Noisebridge and more. He’s also a potter and a mean cook.

  Sessions

  • * Give a Great Tech Talk
    • Title: Give a Great Tech Talk
    • Track: Culture
    • Room: St. Johns
    • Time: 10:00 – 11:45am
    • Excerpt:

      Why do so many technical presentations suck? Make sure that yours
      doesn’t. Josh Berkus and Ian Dees will show you how to share your
      ideas with your audience by speaking effectively and (when the
      situation warrants it) showing your code.

    • Speakers: Josh Berkus, Ian Dees
  • * Relational vs. Non-Relational
    • Title: Relational vs. Non-Relational
    • Track: Cooking
    • Room: Morrison
    • Time: 2:30 – 3:15pm
    • Excerpt:

      What kind of database do you need?

      Thanks to new database projects like CouchDB, TokyoCabinet, Solr and others, there are more non-relational database options available than ever for developers. Yet good information on how to choose what kind of database you need is still scarce. We’ll cure that in this talk.

    • Speakers: Josh Berkus
  • * Introduction to PostgreSQL
    • Title: Introduction to PostgreSQL
    • Track: Cooking
    • Room: Broadway
    • Time: 1:30 – 2:15pm
    • 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.

    • Speakers: Josh Berkus, Christophe Pettus

• Christophe Pettus

  PostgreSQL Experts, Inc.
  • Blog: http://thebuild.com/blog/
  • Twitter: Xof

  Biography

  Christophe Pettus has been developing using PostgreSQL since 1998. He consults on database design and application development through PostgreSQL Experts.

  Sessions

  • * Introduction to PostgreSQL
    • Title: Introduction to PostgreSQL
    • Track: Cooking
    • Room: Broadway
    • Time: 1:30 – 2:15pm
    • 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.

    • Speakers: Josh Berkus, Christophe Pettus