1. This talk would present and end2end look at SLONY including an overview, details of a sample setup of a SLONY cluster, setup details for switchover and failover scripts plus a look at incorporating PG Pool II into the cluster. Topics Covered/TOC:

    Installation & general info
    Setup of a sample SLONY cluster
    initialization/setup of the cluster
    preparing the slave(s)
    the slon daemon
    starting replication
    Walk through of the initialization/setup for the sample cluster
    PG Pool II
    install / setup
    Setup for automated failover
    Walkthrough of end-2-end sample instance

    # vimeo.com/7690878 Uploaded 217 Plays / / 0 Comments Watch in Couch Mode
  2. Most users know that PostgreSQL has a 23-year development history. But did you know that Postgres code is used for over a dozen other database systems? Thanks to our liberal licensing, many companies and open source projects over the years have taken the Postgres or PostgreSQL code, changed it, added things to it, and/or merged it into something else. Illustra, Truviso, Aster, Greenplum, and others have seen the value of Postgres not just as a database but as some darned good code they could use. We'll explore the lineage of these forks, and go into the details of some of the more interesting ones.

    # vimeo.com/7581907 Uploaded 132 Plays / / 0 Comments Watch in Couch Mode
  3. These pieces, when combined, make PostgreSQL able to do almost anything you can imagine. A variety add-ons have been very successful in PostgreSQL merely by using this extensibility. Examples in this talk will range from PostGIS (a GIS extension for PostgreSQL) to DBI-Link (manage any data source accessible via perl DBI).

    # vimeo.com/7192353 Uploaded 168 Plays / / 0 Comments Watch in Couch Mode
  4. Few things we model in our databases are as complicated as time. The major database vendors have struggled for years with implementing the base data types to represent time. And the capabilities and functionality vary wildly among databases. Fortunately PostgreSQL has one of the best implementations out there. We will look at PostgreSQL's core functionality, discuss temporal extensions, modeling temporal data, time travel and bitemporal data.

    # vimeo.com/7177002 Uploaded 460 Plays / / 0 Comments Watch in Couch Mode
  5. A brief introduction to configuring PostgreSQL Replicator.

    # vimeo.com/7176977 Uploaded 303 Plays / / 0 Comments Watch in Couch Mode


Joshua Drake

Dedicated to the World's Most Advanced Open Source Database.

Browse This Channel

Shout Box

  • Alonso Garcia

    Im new to vimeo, but the presentation "SQLAlchemy and PostgreSQL" doesnt show 90 minutes, i think it lasts only 2 or 3!

    by Alonso Garcia

Channels are a simple, beautiful way to showcase and watch videos. Browse more Channels. Channels