|
by: Philippe Lang |
last post by:
Hello,
After using Postgresql for a while, through ODBC / MS Access, I'm not
able to connect to the server anymore. The server reports "Too many
clients connected already".
With a "ps -afx", I can see a lot of idle postgresql connections, which
correspond for sure to ODBC connections that haven't been closed
properly, and that remain opened. Stopping and restarting the server
solves the problem.
|
by: John Gibson |
last post by:
Hi, all.
We are running PostgreSQL 7.2.2 (7.4.1 in a few weeks). We have a
pesky legacy application which periodically leaves open idle
connections. (I know... fix the application). In the short term, I
would like to find out if the database engine has a time-out
configuration option for idle connections where it would force-close
the connections.
Is there such an option?
|
by: Stefan Felkel |
last post by:
hi!
i have searched a lot in these pgsql-groups and on the internet, but
found no really helpful information for my problem.
the famous error
>> database "xyz" is being accessed by other users
is my problem.
|
by: Josh Close |
last post by:
Is there a way to remove idle connections? My postgres server is
getting serveral hundred idle connections. It's due to a postgres .NET
provider not closing the connections properly. I don't want to kill
them all, or restart postgres everytime the connections go crazy.
-Josh
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
|
by: Praveen_db2 |
last post by:
Hi All
I came across a small doubt.
Suppose I have Max Connections parameter set to 200.
There are now 200 connections to the database.
Out of these 200 connections 50 are idle.
What will happen if a new user tries to connect to the database?
Whether he will receive error about MAXCONNECTIONS exceeded or he will be
allotted a connection as 50 agents are idle now?
Also how to kill those idle sessions or connections to make way for active...
|
|
by: elyob |
last post by:
Not really tried going two ways at once, but I have an include_once
connection to a mysql_database, now I need to retrieve info from a second
mysql_database ..
My mysql_connects are getting confused. So, (I've had a couple of beers), am
I opening up too many at once?
I'll look again in the morning, but am thinking that it is a bad idea to
leave two connections open all the time ...
|
by: ron.tornambe |
last post by:
I have a MS-Access database linked to DB2 tables. It appears that
MS-Access or ODBC manages db2 connections, closing them after some
period of inactivity. I need the connections to remain open until the
application is closed by the user. Does anyone know how to accomplish
this?
TIA,
Ron in SF
|
by: Troels Arvin |
last post by:
Hello,
Some of our SAS users seem to initiate 20+ idle connections to DB2 every
time they start SAS. I'm inclined to tell them to cut down on their DB2
connection number, but then again, if the connections are very cheap why
bother.
Are idle DB2 connections cheap, from the DBMS' point of view?
(I fear that there's no easy answer to this question, but maybe someone
|
by: dantz |
last post by:
Having a multiple client/server using a C# httplistener/httpwebrequest to transfer message.
How should I handle idle connections?
Will it be the job of the server or client?
Does using a ping mechanism effective?
Please suggest others ways..
My idea as of now is this:
http://www.koders.com/csharp/fidDA9BB7F0CB74CAC8C021B42DF9EB9DCAFB88845E.aspx?s=httpwebrequest
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
|