<html><head>
</head>
<body class='ant_bdiv'><div style='font-family: Arial, Helvetica, sans-serif;font-size: 10pt;'><span style="font-family: Arial,Helvetica,sans-serif;">I all, thanks in advance for your work and quality support.<br><br>We are working on a multi-master solution for PostgreSQL and were extremely happy to find the pgcluster project. However, we are having some trouble on our test system.<br><br>pgreplicate hangs after a few queries and the clients return "Query not permitted when all replication servers fell down."<br><br>I started pgrepliacte with -n -v and got the following:<br><br>.....<br>2007-08-03 15:45:20 [33583] DEBUG:from_host=10.100.16.45<br>2007-08-03 15:45:20 [33583] DEBUG:dbName=guaranty<br>2007-08-03 15:45:20 [33583] DEBUG:userName=guaranty<br>2007-08-03 15:45:20 [33583] DEBUG:recieve sec=1186181120<br>2007-08-03 15:45:20 [33583] DEBUG:recieve usec=713792<br>2007-08-03 15:45:20 [33583] DEBUG:query_size=21<br>2007-08-03 15:45:20 [33583] DEBUG:request_id=1<br>2007-08-03 15:45:20 [33583] DEBUG:replicate_id=0<br>2007-08-03 15:45:20 [33583] DEBUG:recovery_status=0<br>2007-08-03 15:45:20 [33583] DEBUG:query=PGR_CLOSE_CONNECTION<br>2007-08-03 15:45:20 [33583] DEBUG:sem_lock [1] req<br>2007-08-03 15:45:20 [33583] DEBUG:sem_lock [1] got it<br>2007-08-03 15:45:20 [33583] DEBUG:source host<br>2007-08-03 15:45:20 [33583] DEBUG:replicate_packet_send_internal():connect db:guaranty port:5432 user:guaranty host:devserv2.guaranty.com query:PGR_CLOSE_CONNECTION<br>2007-08-03 15:45:20 [33583] DEBUG:start thread_send_cluster()<br>2007-08-03 15:45:20 [33583] DEBUG:sem_unlock[1]<br><br>Then it just hangs.<br><br>Here is our test configuration:<br><br>Server 1:<br></span><span style="font-family: Arial,Helvetica,sans-serif;">Postgresql Node</span><span style="font-family: Arial,Helvetica,sans-serif;"> 1 & pgreplicate server<br><br>Server 2:<br>Postgresql Node 2<br><br>Both are running FreeBSD 6.0 and pgcluster 1.7.0rc7<br><br>Any suggestions?<br><br>Sincerely,<br><br>Sky<br></span>
</div></body>
</html>