|
Hi! I tried to reply and sincronize two postgres on pgsql1 and pgsql2 , but when pgpool restart the postgres on pgsql2 , pgpool doesn't attend new conection ,Let me explain better the problem, i have the follow stage: 1.- I have postgres running in pgsql1 and postgres is down in pgsql2. 2.- start pgpool, and pgpool detects this fail and enter in degeneration mode. (this is ok, because is the behavior expected) 3. - then launch the pcp_recovery_node program to recover pgsql2 4. pgpool start each one of the stages .... until restart postgres on pgsql2 5. the pcp_recovery program show a message: recovery is done ... 6. i ran psql to check that, but psql doesn't work is waiting .... (this is wrong because the behavior is unexpected..) 7. after that wrong behavior, i must restart pgpool on this way: pgppol -m immediate stop ; pgpool start. run psql again and works fine.... This are the details: postgres is 8.3 running on SCO Openserver 5.0.7 pgpool version is 2.2.6 compiled and running on SCO 5.0.7 i follow the process described in http://linuxsilo.net/articles/postgresql-pgpool.html by the way i have many troubles to compile 2.3 (specially error syntax with sys/byteorder.h ) but that is for another mail :-P, so if you can help me to resolve this issue on pgpool 2.2.6; i will be thankfull with you :-) regards... |
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
