PostgreSQL Replication and Tablespaces by Jim McQuillan @MugOrgPage
PostgreSQL Replication and Tablespaces by Jim McQuillan  @MugOrgPage
Uploaded July 2017 | Updated November 2026, 3 hours ago
PostgreSQL Replication and Tablespaces

PostgreSQL is one of the shining examples of what an Open source project can be. It's an enterprise level relational database management system (RDBMS) that is in use by millions of people all over the world; from small projects consisting of a few megabytes of data to large corporations with terabytes of data to store.

At the June MUG meeting, Jim McQuillan will be discussing 2 interesting and important features of the PostgreSQL database:

Replication - The use of redundant resources to improve reliability, fault-tolerance, or performance.
Tablespaces - Controlling the locations within the filesystem where the files representing the database objects are stored.
Of the two topics, replication is by far the more complicated so we'll be spending most of the time talking about that. In particular, we'll show how to setup and use streaming replication available in PostgreSQL 9.x to provide high availability and load balancing. We'll also peek into the new features that are proposed for PostgreSQL 10.0 that is currently in beta release.


Jim McQuillan has been working professionally in Healthcare IT in the Detroit area for over 30 years and with PostgreSQL for over 15 years. He's been actively involved in the world of Linux and Open source and is the founder of the Linux Terminal Server Project (LTSP.org).
PostgreSQL Replication and Tablespaces by Jim McQuillanUsing SSH in a Scalable and Secure Way by Marlon DutraPostgreSQL Replication (November 10th 2020 - MUG Meeting)Introduction to VASSAL by Craig MaloneyMUG MeetingLive and die by certificates by Mike CooperNetwork Firewalls for Fun and Profit By Tony BemusSSH by Michael W. LucasHigh Performance Computing and FilesystemsRaspberry Pi Wireless Intrusion Detection Systems10 things you dont know about Git - MUG Meeting - April 9, 2025Ansible (November 9th, 2021 Monthly MUG Meeting)
Michigan!/Usr/Group |

PostgreSQL Replication and Tablespaces by Jim McQuillan

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER