Multiconnect HeidiSQL on postreSQL

Nej1's profile image Nej1 posted 12 months ago in General Permalink

Good day. I'm willing to report that Heidi SQL making multiple connections of one user. These connections use resources of server not rational, that leads to problems with server resources management. Waiting for your answer.

1 attachment(s):
  • multiconnect_heidiSQL
ansgar's profile image ansgar posted 12 months ago Permalink

I see only one session using "HeidiSQL" as application name. What makes you think the others are initiated through HeidiSQL as well? The same user name may be also used by the server in the background of a session. The code in HeidiSQL only creates one physical connection per session.

Nej1's profile image Nej1 posted 11 months ago Permalink

Ok. We did some tests and Heidi SQL definitely use only one session. But when we open more than one program Heidi SQL, it uses multiple sessions. Is there any way to lock program to only one run or one session on multiple runs?

ansgar's profile image ansgar posted 11 months ago Permalink

You can disable multiple application instances in HeidiSQL's preferences:

Description

But you will still be able to open multiple sessions in one HeidiSQL instance.

Nej1's profile image Nej1 posted 11 months ago Permalink

Is there a setup using GPO?

ansgar's profile image ansgar posted 11 months ago Permalink

What is GPO?

Nej1's profile image Nej1 posted 11 months ago Permalink

Group Policy Object in Domain

ansgar's profile image ansgar posted 11 months ago Permalink

Oh well, then no, there is no such a thing in HeidiSQL.

Nej1's profile image Nej1 posted 11 months ago Permalink

Disabling multiple application may be possible by changing regedit: reg add HKCU\Software\HeidiSQL /v AllowMultipleInstances /t REG_DWORD /d 0x0 /f

Please login to leave a reply, or register at first.