Slony1 PostgreSQL Replication - subscribing new slave after failover

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

subscribing new slave after failover

Ccmga1-YDxpq3io04c@public.gmane.org

2005-08-05, 7:24 am

I have 2 nodes, node 1 master, node 2 slave. Replication works fine (with
postgresql 8.0.3, slony 1.1.0)
Suppose node 1 is down.
I want to promote node 2 to new master, so I follow the procedure :
step 1 : failover, ok
step 2 : drop node 1, ok
step 3 : store node 1 (new slave), store path and store listen, ok
step 4 : subscribe node 1 as receiver for the set, provider is node 2, ERROR
: fe_sendauth : no password supplied

has anyone the same problem ?

C.Miosga

-----
my node configuration :

first master :
node 1 localhost 5432
node 2 localhost 5500

first slave :
node 1 localhost 5500
node 2 localhost 5432

the 2 databases communicate via ssh tunneling (port 5500 to 5432).

Sponsored Links