Encrypted connection SQL server fdw
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.
On 1/10/20 3:54 AM, Soni M 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?
Take it up with the maintainer?:
https://github.com/tds-fdw/tds_fdw
Thanks,
Soni.
--
Adrian Klaver
adrian.klaver@aklaver.com
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 <diptatapa@gmail.com> wrote:
Show quoted text
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.