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
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
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.
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).
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.