Re: Encrypted connection SQL server fdw

--00000000000006ef10059bcbbceb
Content-Type: text/plain; charset="UTF-8"

By loading data meaning this is a one time deal or only used to refresh
data stored in the postgresql database???

A possible solution would be to setup a vpn tunnel, or ipsec connection to
server.  then run FDW through that connection.  Not idea and will slow
things down.

The other option is to use postgresql ODBC on the MSSQL side to pushed from
MSSQL to Postgresql .

On Fri, Jan 10, 2020 at 6:54 AM Soni M <[email protected]> wrote:

> Hi All,
> currently I'm trying to configure postgres (on centos) to load data from
> MS SQL server (on windows server) on an encrypted connection.
>
> Trying with tds_fdw, but found that it doesn't support encrypted
> connection.
>
> Is there any solution to this?
>
> Thanks,
>
> Soni.
>

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

<div dir=3D"ltr"><div>By loading data meaning this is a one time deal or on=
ly used to refresh data stored in the postgresql database???<br></div><div>=
<br></div><div>A possible solution would be to setup a vpn tunnel, or ipsec=
 connection to server.=C2=A0 then run FDW through that connection.=C2=A0 No=
t idea and will slow things down.</div><div><br></div><div>The other option=
 is to use postgresql ODBC on the MSSQL side to pushed from MSSQL to Postgr=
esql .<br></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=
=3D"gmail_attr">On Fri, Jan 10, 2020 at 6:54 AM Soni M &lt;<a href=3D"mailt=
o:[email protected]">[email protected]</a>&gt; wrote:<br></div><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px=
 solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto">Hi All,<div dir=
=3D"auto">currently I&#39;m trying to configure postgres (on centos) to loa=
d data from MS SQL=C2=A0server (on windows server) on an encrypted connecti=
on.<div dir=3D"auto"><br></div><div dir=3D"auto">Trying with tds_fdw, but f=
ound that it doesn&#39;t support encrypted connection.</div><div dir=3D"aut=
o"><br></div><div dir=3D"auto">Is there any solution to this?</div><div dir=
=3D"auto"><br></div><div dir=3D"auto">Thanks,</div><div dir=3D"auto"><br></=
div><div dir=3D"auto">Soni.</div></div></div>
</blockquote></div>

--00000000000006ef10059bcbbceb--