<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi;</p>
<p><br>
</p>
<p>I have an architecture where I am using Foreign Data Wrappers to
scale <br>
</p>
<p>So I have a read/write db (server a) and it has 2 schemas in it,
schema 1 has a number of foreign tables to server b and schema 2
has a number of foreign tables pointing to server c</p>
<p>for 'writes' the app can simply connect to server a and the FDW's
take care of where the data lives so server a is sort of a
'federated' server<br>
</p>
<p><br>
</p>
<p>I also want to load balance reads, so I have 2 Hot Standby's for
server b and 2 Hot standby's for server c</p>
<p>Then I created 2 new 'federated' servers and these servers have
Foreign servers defined that connect to the Hot standby nodes,
something like this</p>
<p><br>
</p>
<img src="cid:part1.HUJnNBRQ.zowIf7RI@quadratum-braccas.com"
moz-do-not-send="false">
<p><br>
</p>
<p>Question:</p>
<p><br>
</p>
<p>Is it possible to have pgpool send all writes to server a and
then load balance reads across servers e and h (note that e and h
are actually read/write clusters)?<br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
</body>
</html>