Thread: 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:
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.