Phoenix Kiula phoenix.kiula at gmail.com
Mon Aug 25 23:39:16 PDT 2008
HI

On the PG-General list, I was recommended to look at Slony as I wish
to upgrade from PG 8.2.3 to the latest 8.3.3 without significant
downtime.

I have a very typical CentOS 4.4 Linux server with Cpanel/WHM.
Postgresql is used to work with Apache and PHP n a very busy site.

I am looking for simple instructions to

1. Install Slony

2. Install PG 8.3.3, and make sure it is working with same settings in
"pg_hba.conf" and "postgresql.conf" as my current working db

3. Replicate my current working db of PG 8.2.3 to this new installed
8.3.3 using Slony? (I am not familiar with master and slave stuff, so
simple instructions would be nice)

4. When all data is replicated and working, just switch the master and
slave, so that the new 8.3.3 becomes the main database

Are there any simple straightforward instructions for this that don't
assume that I'm a super techsavvy DBA with 300 years of experience?

Thanks! for any advice or pointers.


More information about the Slony1-general mailing list