Cybercluster Quickstart Guide
Jan. 18th, 2008 08:15 amWriting this down quickly so I can write out full docs later:
wget http://www.postgresql.at/download/etch/cybercluster_1.0.0_i386.deb
apt-get remove postgresql
dpkg -i cybercluster_1.0.0_i386.deb
edit /etc/hosts to contain proper entries for all cluster nodes
edit /var/lib/postgresql/data/cluster.conf to taste
edit /var/lib/postgresql/data/pg_hba.conf to allow trust connect from all nodes
edit /var/lib/postgresql/data/postgres.conf to allow connect from all nodes and clients
/etc/init.d/cybercluster restart
su - postgres -m -c "psql"
CREATE ROLE root SUPERUSER LOGIN CREATDB CREATEROLE;
for replication server only (WARNING. DON'T USE MORE THAN ONE REPLICATION SERVER. THIS FEATURE IS BROKEN):
cp /user/share/postgresql/pgreplicate.conf.sample /etc/pgreplicate.conf
edit /etc/pgreplicate.conf to taste
write script for /etc/init.d/pgreplicate (I still need to do this)
pgreplicate -D /etc
Done!
wget http://www.postgresql.at/download/etch/cybercluster_1.0.0_i386.deb
apt-get remove postgresql
dpkg -i cybercluster_1.0.0_i386.deb
edit /etc/hosts to contain proper entries for all cluster nodes
edit /var/lib/postgresql/data/cluster.conf to taste
edit /var/lib/postgresql/data/pg_hba.conf to allow trust connect from all nodes
edit /var/lib/postgresql/data/postgres.conf to allow connect from all nodes and clients
/etc/init.d/cybercluster restart
su - postgres -m -c "psql"
CREATE ROLE root SUPERUSER LOGIN CREATDB CREATEROLE;
for replication server only (WARNING. DON'T USE MORE THAN ONE REPLICATION SERVER. THIS FEATURE IS BROKEN):
cp /user/share/postgresql/pgreplicate.conf.sample /etc/pgreplicate.conf
edit /etc/pgreplicate.conf to taste
write script for /etc/init.d/pgreplicate (I still need to do this)
pgreplicate -D /etc
Done!