<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi!<br>
<br>
If you can shutdown in an predefined order that the primary should
get down as the last. Later start it first, then recover the
others. <br>
If the shutdown order is random, you can end up with several
servers promoted to be primary. Then the one most recently
shutdown should be started as primary, the others should use
recovery procedure. If the computer clocks are reasonably in sync,
then one can try to check logs to find out which one was shut down
as the last one.<br>
<br>
I am not sure if I got your problem properly, though...<br>
<br>
Cheers!<br>
J.<br>
<br>
<br>
On 16.06.2015 17:24, Jose Baez wrote:<br>
</div>
<blockquote
cite="mid:CAJ5xMx=P+mdSQemRBzzW-kfAz3hWbtYb-FgXGi3HXhBuS2Tneg@mail.gmail.com"
type="cite">
<div dir="ltr">Hi!
<div><br>
</div>
<div>In one of my scenarios DDBB servers need to shutdown from
time to time (servers are mounted on a vehicle which has to
shutdown servers when moving).</div>
<div><br>
</div>
<div><b>Question is about failover</b> and "sharing status
information" (with master/master replication in PSQL).<br>
</div>
<div><br>
</div>
<div><b>If PSQL node fails</b> (which is running pgpool with
watchdog <b>in standby mode</b> and a PSQL instance), the
other PSQL node (with active Pgpool) will detect that one PSQL
node has failed and, at same time, will send the Queries to
the second PSQL node only.</div>
<div><br>
</div>
<div>As the first node is stopped, first pgpool's watchdog
hasn't been able to receive the new status information.<br>
</div>
<div><br>
</div>
<div>After a while, every vehicle's server get shuts down.</div>
<div><br>
</div>
<div>When starting servers next time, if the first pgpool is the
active one, it won't know about the most updated status
information: <b>it will see both PSQL nodes as OK status</b>,
won't it ? Which pgpool instance will run as active?</div>
<div><br>
</div>
<div>
<div>Can i make both Pgpool to save/read the same
"status_file" from a shared network drive... would it work
if there is only 1 pgpool instance at same time? Does the
file need specific permissions/owner?<br>
</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div>Is there a robust Pgpool configuration which involves
shutting down servers often? Would Streaming-Replication
suits better?</div>
<div><br>
</div>
<div>Thank you.<br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>
<div><br>
</div>
</div>
</div>
</blockquote>
<br>
</body>
</html>