Обсуждение: POSIX and libpq

Hi list.

Does someone know if there is some kind of incompatibility  between POSIX
(glibc 2.4) and libpq (postgres 8.2) on Linux RedHat 5.0?

Thanks in advance

Luca
 --
 Email.it, the professional e-mail, gratis per te: http://www.email.it/f

 Sponsor:
 In REGALO 'All the Good Thing' di NELLY FURTADO
 Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6617&d=20071211

luca.ciciriello@email.it wrote:
> Hi list.
>
> Does someone know if there is some kind of incompatibility  between POSIX
> (glibc 2.4) and libpq (postgres 8.2) on Linux RedHat 5.0?

Do you really mean RedHat 5.0 - the one released in 1997?

--
   Richard Huxton
   Archonet Ltd

Sorry, my information was not complete.
The Linux version is Linux AS 5.0 Enterprise

Luca

--------- Original Message --------
    Da: Richard Huxton <dev@archonet.com>
    To:
            Cc: pgsql-general@postgresql.org
    Oggetto: Re: [GENERAL] POSIX and libpq
    Data: 11/12/07 19:36

    >
>
>
> luca.ciciriello@email.it wrote:
> > Hi list.
> >
> > Does someone know if there is some kind of incompatibility  between
POSIX
> > (glibc 2.4) and libpq (postgres 8.2) on Linux RedHat 5.0?
>
> Do you really mean RedHat 5.0 - the one released in 1997?
>
> --
>    Richard Huxton
>    Archonet Ltd
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>
>
>
 --
 Email.it, the professional e-mail, gratis per te: http://www.email.it/f

 Sponsor:
 Fai squillare la PANTERA ROSA sul tuo cellulare: e' in REGALO
 Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6613&d=20071211

luca.ciciriello@email.it wrote:
>>> Does someone know if there is some kind of incompatibility  between
> POSIX
>>> (glibc 2.4) and libpq (postgres 8.2) on Linux RedHat 5.0?
>> Do you really mean RedHat 5.0 - the one released in 1997?

 > Sorry, my information was not complete.
 > The Linux version is Linux AS 5.0 Enterprise

Seems unlikely that it wouldn't compile on RH's latest enterprise system.

What problems are you encountering?

--
   Richard Huxton
   Archonet Ltd

Richard Huxton <dev@archonet.com> writes:
>>> luca.ciciriello@email.it wrote:
>>>> Does someone know if there is some kind of incompatibility  between
>>>> POSIX (glibc 2.4) and libpq (postgres 8.2) on Linux RedHat 5.0?

>>> Do you really mean RedHat 5.0 - the one released in 1997?

>> Sorry, my information was not complete.
>> The Linux version is Linux AS 5.0 Enterprise

> Seems unlikely that it wouldn't compile on RH's latest enterprise system.
> What problems are you encountering?

Something fishy here though, because RHEL5 ships glibc-2.5 not 2.4,
if I'm reading Red Hat's CVS correctly.

I wonder whether Luca is trying to use a libpq.so that was compiled on
some other Linux release with a different glibc version.

            regards, tom lane

I've a multithread application running on Linux. In each thread i've a loop
performing a single INSERT operation on the DB.
Sometimes (not always), two of the three thread die apparently without any
reason. The strange thing is that if I remove the store operation from
the threads, all runs fine. Viceversa, if I run the INSERT loops out of the
threads all runs the DB operation are executed without any problems.

On Linux I'm super user and I create the three thread using the posix
function pthread_create. The same code, on windows, doesn't present any
problem (in windows  I use CreateThread function).

That is all.

Luca

--------- Original Message --------
    Da: Richard Huxton <dev@archonet.com>
    To:
            Cc: pgsql-general@postgresql.org
    Oggetto: Re: [GENERAL] POSIX and libpq
    Data: 11/12/07 21:31

    >
>
>
> luca.ciciriello@email.it wrote:
> >>> Does someone know if there is some kind of incompatibility  between
> > POSIX
> >>> (glibc 2.4) and libpq (postgres 8.2) on Linux RedHat 5.0?
> >> Do you really mean RedHat 5.0 - the one released in 1997?
>
>  > Sorry, my information was not complete.
>  > The Linux version is Linux AS 5.0 Enterprise
>
> Seems unlikely that it wouldn't compile on RH's latest enterprise system.
>
> What problems are you encountering?
>
> --
>    Richard Huxton
>    Archonet Ltd
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>
>
>
 --
 Email.it, the professional e-mail, gratis per te: http://www.email.it/f

 Sponsor:
 Fiorucci Pin-Up Collection: scopri le nuove fragranze e...vinci 1000 Euro
di shopping in limousine!

 Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=7262&d=20071212

luca.ciciriello@email.it wrote:
> I've a multithread application running on Linux. In each thread i've a loop
> performing a single INSERT operation on the DB.
> Sometimes (not always), two of the three thread die apparently without any
> reason. The strange thing is that if I remove the store operation from
> the threads, all runs fine. Viceversa, if I run the INSERT loops out of the
> threads all runs the DB operation are executed without any problems.
>
> On Linux I'm super user and I create the three thread using the posix
> function pthread_create. The same code, on windows, doesn't present any
> problem (in windows  I use CreateThread function).

It's almost certainly a threading problem. Have you read the relevant
section of the manuals?
http://www.postgresql.org/docs/8.2/static/libpq-threading.html


--
   Richard Huxton
   Archonet Ltd