Does anyone know what replication options are available for PostgreSQL databases? So far I’ve found the below replication options:
- PostgreSQL Replication – made available in version 9 – there seem to be a few forms of this
- Scripted replication – just write some scripts and schedule them to run, in order to replicate your database content
- VM layer replication – such as VMware SRM, and HA / FT, also there are Microsoft Hypervisor equivalents
- SAN Replication
- Slony
- PostgreSQL Clustering
- EnterpriseDB seem to also offer a replication option for PostgreSQL