- How much can I extend PGCluster?
The default maximum number of Cluster DB nodes is 128. If you need more nodes you may change the maximum nodes value in the configuration. However, increasing number of cluster nodes has a side effect of increasing the load of the replication and the load balancing servers. You better have a sane number of Cluster DB nodes depending on your hardware.
- Is it possible to run a replication server and Cluster DB server on the same machine?
It is possible since PGCluster-1.0.6rc4. But for this kind of systems which needs load balancing and high-availability, such system composition is unreliable. If load balancing or high-availability is really required in your system, you should run independent replication server[s].
- Is it necessary to execute the VACUUM command for each Cluster DB independently?
The VACUUM command and The VACUUM FULL commands are reproduced on each Cluster DB nodes. For reliability, it is better to stop the system and to execute VACUUM FULL command on each Cluster DB independently.
- Is a backup command replicated?
PGCluster does not replicate neither pg_dump nor the COPY (TO) command.
Return to Wiki Start
