Hi,

For various reasons i was forced to rebuild a complete cluster. Currently i have two nodes, master and slave and there are many clients accessing the slave node, hence one of the restrictions was to "interrupt the service the minimum posible". 

Resuming, i device the next strategy: "create a new subscriber database and then rename to the original", in steps:

1.- Stop synchronizing for while, i can handle be off line for some minutes.
2.- Create an empty subscriber database with another name, say db_subscriber_temp.
3.- Create all the cluster from scratch, using the aforementioned new subscriber database.
4.- Let replication working fine with the new database.
5.- Rename new database to the published name say: rename db_subscriber_temp to db_subscriber.  

I'am using altperl tools, and i modify the /usr/local/etc/slon_tools.conf file, first to make the new cluster definition works, and then switch back to the original version after renaming the database to the published name.  

It seems to be that slony metadata is still pointing to the old names, and i need to modify it. I googled for a while and found some tips for renaming nodes, but no databases, after all, i run some slonik commands with no result. 

Question: How to rename a database.

Thanks
Hans 

-- 
Hans Poo, WeLinux S.A.
Oficina: 697.25.42, Celular: 09-319.93.05
Bombero Ossa # 1010, Santiago