FAQs

When you have any question about PGCluster, please mail here.


Q1: How many can I extend Cluster DB?
The number of the maximums of Cluster DB is 128. If you need more Cluster DBs , you can also change a maximum value. However, if Cluster DB server is extended, the load of a replication server and a load balance server will increase. You had better extend it only the required minimum number to your system.
Q2: Is it possible to run a replication server and Cluster DB server on one machine?
It is possible when you use pgcluster-1.0.6cv4 or later. But probably, in the system which needs a load balance and a high-availability, such system composition will be dangerous. If a load balance or a high-availability is required in your system, you should run a replication server independently.
Q3: Is it necessary to execute the VACUUM command for every Cluster DB?
When you execute the VACUUM command to one Cluster DB, a command will be reproduced and will be executed in all the Cluster DBs. If you execute the VACUUM FULL command to Cluster DB, the VACUUM FULL command is executed in all the Cluster DBs. Probably, it will be better to have stopped the system and to execute one command at a time, when you want to execute the VACUUM FULL command.
Q4: Is a backup command replicated?
PGCluster replicates neither pg_dump nor the COPY (TO) command.
Q5: Does PGCluster support the latest version of PostgreSQL?
PGCluster-1.1.0 are made based on PostgreSQL7.4.6. I am going to make PGCluster Which is based on PostgreSQL8.0 after next version.