Is possible to create a shared-storage postgresql server cluster?

0
Posted

Is possible to create a shared-storage postgresql server cluster?

0
AnnetFowler Kallykally777@gmail.com

Working with this software is really easy for a programmer. If you want to develop your coding faster and better, I can recommend to use PostgreSQL Reporting Tools – Visualize PostgreSQL data which is a user-friendly solution, that allows to code, to refresh your data and to manage it between databases.

0

PostgreSQL does not support clustering using shared storage on a SAN, SCSI backplane, iSCSI volume, or other shared media. Such “RAC-style” clustering isn’t supported. Only replication-based clustering is currently supported. See Replication, Clustering, and Connection Pooling information for details. Shared-storage ‘failover’ is possible, but it is not safe to have more than one postmaster running and accessing the data store at the same time. Heartbeat and STONITH or some other hard-disconnect option are recommended.

Related Questions