Hi,

slony can do that for you yes, where you have a maximum downtime of 
maybe 2-6 minutes. (if you want to keep new database on same machine and 
on same port)

I'm currently doing this migration though from 8.2.4 -> 8.3.3 though im 
doing it on 5 nodes..

pg_hba.conf is more or less the same between version so no problem 
there, for the postgresql.conf there are some changes.. so that you will 
need to investigate a bit more, you cant just copy over the 
postgresql.conf (the pg-General should know more on this)

I've written a rather detailed document on how to do migration using 
slony, though it does contain some company specific steps so I can not 
just put it out there, i would need to clean it up a bit first. Will see 
if i got the time time to do it today or tomorrow.

but if you never heard of slony I would recommend read up a bit on it 
first to understand the fundamentals.

regards
Martin


Phoenix Kiula wrote:
> 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.
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>