Cybercluster Quickstart Guide

[inaki]

Writing 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!

Comments

[timberwuf.livejournal.com]

This instruction gives me the willies:
"edit /var/lib/postgresql/data/cluster.conf to taste"

I guess I'll have to post how to do a kinda sorta not really similar thing with MySQL.

[inaki.livejournal.com]

Oh this is just a quickstart guide written up really quickly so I have all the steps. I'll be working out proper documentation shortly.

I also need to work on securing the internode links better than they are currently.