Vick,

Yes, may be proxying, i will take a look further to that solution... it's just that i tought it was going to be easier to modify slony metadata, or even the possibility to find a standard procedure to do what i wanted...

Thank you
Hans

----- "Vick Khera" <vivek at khera.org> escribió:

> On Fri, Jun 5, 2009 at 10:20 AM, <hans at welinux.cl> wrote:
> > 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".
> 
> How about installing a Postgres proxy on the slave node on port 5432
> that forwards connections to the master, then rebuild the DB running
> on a different port.  Then when it is rebuilt just turn off the proxy
> and rest the server to the default postgres port on the slave.

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