Skip site navigation (1) Skip section navigation (2)

Re: Connection of postgres

From: "Nguyen, Lam Thuy" <l7nguyen(at)fcg(dot)com>
To: "Andrei Kovalevski" <andyk(at)commandprompt(dot)com>
Cc: "Malm Paul" <paul(dot)malm(at)saabgroup(dot)com>,<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Connection of postgres
Date: 2008-04-07 02:40:03
Message-ID: C3D5057033EDF145B90A99CD9025BFEA01C601FC@hont05.fcg.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Kovalevski ,
 
I am sure there was no prolem with network. I guess maybe postgres database can not handle if there are many connections work concurrenly.
 
Lam

________________________________

From: Andrei Kovalevski [mailto:andyk(at)commandprompt(dot)com]
Sent: Sun 4/6/2008 10:26 PM
To: Nguyen, Lam Thuy
Cc: Malm Paul; pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] Connection of postgres


I'm figuring similar behaviour with Linux PostgreSQL server  and Win32 client, connection over Internet (not LAN). Not sure what is the source of this problem but it could be something network relative.

Nguyen, Lam Thuy wrote: 

	yes, it is right.
	
	________________________________
	
	From: Andrei Kovalevski [mailto:andyk(at)commandprompt(dot)com]
	Sent: Sun 4/6/2008 9:35 PM
	To: Nguyen, Lam Thuy
	Cc: Malm Paul; pgsql-odbc(at)postgresql(dot)org
	Subject: Re: [ODBC] Connection of postgres
	
	
	
	Hello,
	
	Does it happen after some idle period?
	
	Nguyen, Lam Thuy wrote:
	  

		Hey,
		
		I have a problem with connection of postgres.
		I am using postgres 8.03.01.
		
		I have a telecom program which have 248 channels and each channel hold a connection to postgres database, mean i have 248 opening connections.
		
		When a channel is run, it means it begin to excute some queries to postgres, i got the error :  SQL Error State:   08S01
		
		                                    Native Error Code: 1A
		
		                                    ODBC Error:        Could not send
		Query(connection dead);
		
		                          Could not send Query(connection dead)
		
		
		Could you help me on this ?
		
		
		Thanks you very much
		Lam
		
		
		
		
		
		
		This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the intended recipient.  Any review, reliance, or distribution by others or forwarding without express permission is strictly prohibited.  If you are not the intended recipient, please contact the sender and delete all copies.
		
		 
		    

	--
	Andrei Kovalevski
	PostgreSQL Replication, Consulting, Custom Development, 24x7 support
	Managed Services, Shared and Dedicated Hosting
	Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/
	
	
	
	
	This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the intended recipient.  Any review, reliance, or distribution by others or forwarding without express permission is strictly prohibited.  If you are not the intended recipient, please contact the sender and delete all copies.
	
	  



-- 
Andrei Kovalevski
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/

This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the intended recipient.  Any review, reliance, or distribution by others or forwarding without express permission is strictly prohibited.  If you are not the intended recipient, please contact the sender and delete all copies.

In response to

Responses

pgsql-odbc by date

Next:From: Andrei KovalevskiDate: 2008-04-07 02:41:47
Subject: Re: Connection Pooling
Previous:From: Andrei KovalevskiDate: 2008-04-07 02:26:00
Subject: Re: Connection of postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group