tds-fdw / tds_fdw

A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
Other
381 stars 102 forks source link

Does tds_fdw have a connection pooling function? #360

Open YANGJUHEE521 opened 4 months ago

YANGJUHEE521 commented 4 months ago

Issue report

Hello, I need sql server data, so I'm using tds_fdw. tds_fdw doesn't seem to have a connection pooling function, so I'm asking.

Does tds_fdw have a connection pooling function? If so, how do I set it?

Thank you.

Operating system

Ubuntu 22.04.2(Jammy)

Version of tds_fdw

2.0.1

Version of PostgreSQL

15.3

Version of FreeTDS

freedts-common 1.3.6-1
juliogonzalez commented 4 months ago

Never had to use it, but I'd assume that since tds_fdw uses FreeTDS, this is something you need to configure at FreeTDS itself: https://www.freetds.org/userguide/tdspool.html

Configuring FreeTDS is something that's already done for encoding or encription.

Be aware of the restrictions outlined at the doc.

If you are able to configure it to work, it would be great if you can later write it here, so others can learn about it.