Postgres Pro
Downloads
Home   >   mailing lists

Re: Encrypted connection SQL server fdw - Mailing list pgsql-general

From Justin
Subject Re: Encrypted connection SQL server fdw
Date
Msg-id CALL-XeO+RSVhYMbDAv7j7c0bdODvuwycw67KhAmt5Fb_9K-ddQ@mail.gmail.com
Whole thread Raw
In response to Encrypted connection SQL server fdw  (Soni M <diptatapa@gmail.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Encrypted connection SQL server fdw
Next
From: Israel Brewster
Date:
Subject: Re: UPDATE many records