FOSSLC is a non-profit organization that specializes in technology and know-how to record conferences with excellent quality. Click on the icons below to view great videos from communities we are actively involved with:

 

PostGIS Replication

in FOSS4G, FOSS4G2011, Video, OSGeo
OSGeo

Database replication allows you to distribute spatial queries to multiple servers increasing the scalability and fault-tolerance of your database.

Two popular methods of replicating PostGIS databases are PostgreSQL 9.0's hot-standby replication and the Slony-I replication system. This talk will explain why you want to replicate your PostGIS databases and provide an overview of both Slony-I and hot-standby. The talk will explain the key features and limitations of each and help you choose which technology is appropriate for your situation.

 

Minutes: 
20
Event: 
FOSS4G2011
Speaker: 
Steve Singer
Filmed: 
16.09.2011