Re: Postgres connectivity problem. - Mailing list pgsql-general

From John R Pierce
Subject Re: Postgres connectivity problem.
Date
Msg-id 4A35FCFD.7090600@hogranch.com
Whole thread Raw
In response to Postgres connectivity problem.  ("Bhujbal, Santosh" <sbhujbal@starentnetworks.com>)
List pgsql-general
Bhujbal, Santosh wrote:
>
> Hi All,
>
> Postgres ‘psql’ client is getting hang in ‘stat’ call while connecting
> to postgres server.
>
> Pstack output:
>
> 11017: ./bin/psql -U postgres configdb
>
> 00000000 stat (ff3f5640, ffbff578)
>
> My machine details:
>
> SunOS my_machine 5.10 Generic_120011-14 sun4u sparc SUNW,Sun-Fire-V245
>
> Postgres version:
>
> PostgreSQL 8.2.0 on sparc-sun-solaris2.8, compiled by
> /export/home/uxapps/studio6/SUNWspro/bin/cc –Xa
>

ancient version of postgres, complied with a rather old sun compiler on
a fairly old solaris version, where do we start?
The 8.2 family is up to 8.2.13, and the .0 release of any major.minor
version tends to be on the buggy side.

did this server work right in the past and just stopped workinig, or was
it just built, or what?


solaris 10 as of the last couple incremental releases comes with
postgres 8.2 32 and 64bit precompiled and configured to run from SMF


I would use those, not this old old 8.2.0 build you seem to have.


pgsql-general by date:

Previous
From: "Bhujbal, Santosh"
Date:
Subject: Postgres connectivity problem.
Next
From: aryoo
Date:
Subject: Re: WITH RECURSIVE clause -- all full and partial paths