inaki: (feet)
[personal profile] 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!
This account has disabled anonymous posting.
If you don't have an account you can create one now.
HTML doesn't work in the subject.
More info about formatting

Profile

inaki: (Default)
Inaki

August 2011

S M T W T F S
 123456
7891011 1213
14151617181920
21222324252627
28293031   

Style Credit

Expand Cut Tags

No cut tags
Page generated Mar. 2nd, 2026 02:31 pm
Powered by Dreamwidth Studios