I have a problem using Linked Server in MS SQL Server 2008 (10.0.1600) over Windows Server 2008 R2, to PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Ubuntu 4.3.3-5ubuntu4) 4.3.3.
Additional, the connection to Postgresql are controlled by connection pools (we have test with pgpool and pgbouncer).
Our client/server application (.NET) establish a connection to ms sqlserver, execute an operation in a transaction (distributed): insert in some ms sqlserver table and execute a postgres function (by linked server), and close the connection to ms sql server.
But occur that the postgresql server cache become full. It seems to be that connection coming from sql server doesn't close and go on open new connection every time.
What am I doing bad?
Is some configuration absent?
Sorry by my english.