Is it possible to replicate through an http proxy?

--00000000000090d780059c190227
Content-Type: text/plain; charset="UTF-8"

Hi all,

for a project we are working on we have the following requirements:
* PostgreSQL server on cloud
* Lot of edge devices that need access to DB
* Edges will only execute SELECT queries. No modification allowed on them.
* Internet access on edges can be lost and data must be accessible while
connection is reestablished.

Our first approach to solve this was to setup a postgreSQL server on each
edge and configure a logical replication from cloud server. This way our
clients always connect to local server who automatically syncs with cloud
server while Internet connection is up and also automatically reconnects
when Internet connection is recovered after connection lost.

However, we facing a new requirement that we do not know how to solve. This
requirement is that access to Internet from edge devices must be done
through a http proxy server. Reading documentation we have not been able to
find a way to create a replication with this limitation. The questions we
would like to ask are:
* Is it possible to create a logical replication with this limitation?
* Is there an alternative solution to our problem bearing in mind this
limitation?

Thank you very much!

--00000000000090d780059c190227
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi all,</div><div><br></div><div>for a project we are=
 working on we have the following requirements:</div><div>* PostgreSQL serv=
er on cloud</div><div>* Lot of edge devices that need access to DB</div><di=
v>* Edges will only execute SELECT queries. No modification allowed on them=
.<br></div><div>* Internet access on edges can be lost and data must be acc=
essible while connection is reestablished.</div><div><br></div><div>Our fir=
st approach to solve this was to setup a postgreSQL server on each edge and=
 configure a logical replication from cloud server. This way our clients al=
ways connect to local server who automatically syncs with cloud server whil=
e Internet connection is up and also automatically reconnects when Internet=
 connection is recovered after connection lost.</div><div><br></div><div>Ho=
wever, we facing a new requirement that we do not know how to solve. This r=
equirement is that access to Internet from edge devices must be done throug=
h a http proxy server. Reading documentation we have not been able to find =
a way to create a replication with this limitation. The questions we would =
like to ask are:</div><div>* Is it possible to create a logical replication=
 with this limitation?</div><div>* Is there an alternative solution to our =
problem bearing in mind this limitation?</div><div><br></div><div>Thank you=
 very much!<br></div></div>

--00000000000090d780059c190227--