Re: 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/