Problem: connections doesn't close - linked server

Report PGNP bugs.

Problem: connections doesn't close - linked server

Postby jmarin » Mon Oct 10, 2011 6:01 am

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.

José Marín
Posts: 1
Joined: Mon Oct 10, 2011 5:30 am

Re: Problem: connections doesn't close - linked server

Postby Moderator » Mon Oct 10, 2011 7:48 pm

Jose, we'll try to reproduce the issue and will let you know.

Thank you!
User avatar
Site Admin
Posts: 362
Joined: Wed Oct 29, 2008 11:27 pm

Return to Report Bugs

Who is online

Users browsing this forum: No registered users and 1 guest