On Fri, Nov 13, 2009 at 10:07 AM, Marek Peca wrote:
> Dear Vick,
>
>> I have very similar code written in Perl, and I never observe failures
>> like you see after a timeout on the select call. This code has been
>> in production on farily busy systems for several years now.
>
> can you tell me, w
On Fri, 13 Nov 2009, Tom Lane wrote:
Well, if you *never* get a failure, then yeah I think you have a broken
TCP stack. The default timeouts on this sort of thing are annoyingly
long, but they aren't infinite.
Yes, this is the case. Both ends are running on GNU/Linux system and I
expect that
Marek Peca writes:
>> In any case, that complaint should be directed to your kernel vendor
>> not us. We do not control how long the TCP stack waits before declaring
>> the connection dead.
> Well, this is what I wanted to hear. So if I call PQstatus() or PQexec(),
> the libpq sends some data t
"Several hours" might be more like it.
Better than infinity, of course.
How long have you waited?
Two days, for example.
In any case, that complaint should be directed to your kernel vendor
not us. We do not control how long the TCP stack waits before declaring
the connection dead.
Wel
Marek Peca writes:
> However: I can not get the point, why does the PQexec() (or PQstatus() at
> least) hang, instead of returning some error? I know, that situation with
> broken TCP connection may involve long timeouts, but it could return at
> least after several minutes, couldn't it?
"Seve
On Fri, 13 Nov 2009, Tom Lane wrote:
What that sounds like is a network-level problem. In particular, if
there's a NAT-capable router between your client and server machines,
it's probably dropping the connection after a certain period of
inactivity.
Yes, it probably is. The connection goes th
Marek Peca writes:
> The problem: most of time, everything works fine, hundreds of successful
> or even timed-out selects() get handled without any problem. But time to
> time (eg. after several hours), the select() call returns with a timeout
> and then, a request to the opened PQconn (simple
Dear Vick,
I have very similar code written in Perl, and I never observe failures
like you see after a timeout on the select call. This code has been
in production on farily busy systems for several years now.
can you tell me, which libpq and server versions you are running on?
I have constan
On Fri, Nov 13, 2009 at 9:22 AM, Marek Peca wrote:
> Please, can you tell me, what am I doing wrong?
I have very similar code written in Perl, and I never observe failures
like you see after a timeout on the select call. This code has been
in production on farily busy systems for several years n
On Mon, 2005-02-28 at 16:43, Mohsen Pahlevanzadeh wrote:
> Dears,I need to connect to the PostgreSQL without choosing database in C.
> Please guide me..
You have to choose a database. You can choose template1 which should
always be there. Connections in libpq are to specific databases.
10 matches
Mail list logo
