Re: Encrypted connection SQL server fdw

2020-01-10 Thread Justin
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 u

Re: Encrypted connection SQL server fdw

2020-01-10 Thread Adrian Klaver
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 i

Encrypted connection SQL server fdw

2020-01-10 Thread Soni M
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.