Thread: Postgres connectivity problem.

This email and any attachments may contain legally privileged and/or confidential information of Starent Networks, Corp. and is intended only for the individual or entity named in the message. The information transmitted may not be used to create or change any contractual obligations of Starent Networks, Corp. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this e-mail and its attachments by persons or entities other than the intended recipient is prohibited. If you are not the intended recipient, please notify the sender immediately -- by replying to this message or by sending an email to postmaster@starentnetworks.com -- and destroy all copies of this message and any attachments without reading or disclosing their contents. Thank you.

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.