2007/5/18, Pallav Kalva <pkalva at livedatagroup.com>:
> Hi,
>
>     I am in process of upgrading my database from postgres8.0 to
> postgres8.2 using slony. I have simple master to slave setup.
>
>     Once slave is in sync with the master what is the process of
> switchover to slave cleanly so that I can start all my applications
> point to the new slave db ?

Have you read <http://slony.info/documentation/failover.html>?

Exactly as said there, use MOVE SET to change origin, then reconfigure apps.

IMHO, after the switchover it's good to leave replication running for
some time, for two reasons:
1) in case of problems you can switch back quickly
2) Slony will guard replicated tables on your "retired" server from
being UPDATE'd by misconfigured apps.


>     At present we are going slony route to make our upgrade process
> quick, so after the upgrade we will delete the postgres8.0 db.

remember to stop new db from replicating; you can use UNINSTALL NODE
http://slony.info/documentation/stmtuninstallnode.html

>
>    I am not sure if I need to do switchover or failover for this process ?

This is switchover. Failover assumes that other server cannot come back ever.




-- 
Filip Rembiałkowski