Is possible to create a shared-storage postgresql server cluster?
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.
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
- ACID cannot connect to the database server. Is it possible that PostgreSQL is only accepting connections through a local socket?
- Is it possible to install multiple instances of Tomcat on one server to create a development, test and production version?
- Is it possible to create non-NT PPTP connections to an NT Server?
