Re: Can't connect to my postgresql

This only happen when in my pg_hba.conf file I put password on the
method validation for local, instead the default trust.

I suppose is due to openssl :(
I'll have to rebuild the application whitout support for it ( i compiled
without it in other machine and all is fine )

Could be the pam support instead?

Daniel Rubio wrote:
> Yes, there's a core in the data directory, here is the stack trace:
>
> bash-2.03# pstack /apps/pgsql-7.3.2/data/core
> core '/apps/pgsql-7.3.2/data/core' of 6308:
> /apps/pgsql-7.3.2/bin/postmaster -D /apps/pgsql-7.3.2/da
> 00123e24 user_group_bsearch_cmp (33d689, 0, ffffffff, 0, 0, 0) + 10
> fef36048 bsearch (8, fffffffc, 0, 4, 0, 123e14) + 4c
> 00123ecc get_user_line (33d689, a, 1, 2, 0, 8000) + 30
> 00122ccc md5_crypt_verify (33d558, 33d689, 32a188, 318249, 2b4198,
> 2d0ea3) + 2c
> 00122c70 recv_and_check_password_packet (33d558, 3, 0, ffffffff,
> fffffff8, ffbeffc1) + f0
> 001223f4 ClientAuthentication (33d558, 33d648, 2b4198, fefbc004, 221d4,
> 172908) + 1b8
> 00172c34 DoBackend (33d558, 1, 0, ffffffff, 22658, 1724e4) + 3f4
> 001724f0 BackendStartup (33d558, 5, ffbef7e8, 1, 221d4, 1707ec) + b0
> 001708e8 ServerLoop (2e3cac, 1896, fefbf54c, fefc2938, fefbc004,
> fefc2938) + 370
> 0017015c PostmasterMain (3, 323910, 74657200, 65720000, 74657200, 0) + ca4
> 00129b0c main (3, ffbefd6c, ffbefd7c, 317e30, 0, 0) + 2d0
> 00032d84 _start (0, 0, 0, 0, 0, 0) + 5c
>
> I hope it may help ... i don't understand almost nothing!
>
> Tom Lane wrote:
>
>> Daniel Rubio <drubior(at)tinet(dot)org> writes:
>>
>>> I've recently installed postgres in a new computer running solaris 8,
>>> and I can't connect to it running psql. When I try it the response is:
>>> bash-2.03$ ./psql
>>> Password:
>>> psql: server closed the connection unexpectedly
>>
>>
>>
>> Can you provide a debugger stack trace? This should be leaving a core
>> dump file in the database subdirectory ($PGDATA/base/something/core).
>>
>> regards, tom lane
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 5: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/docs/faqs/FAQ.html
>>
>
>

--
********************************************************
Daniel Rubio Rodríguez
OASI (Organisme Autònom Per la Societat de la Informació)
c/ Assalt, 12
43003 - Tarragona
Tef.: 977.244.007 - Fax: 977.224.517
e-mail: drubio(at)oasi(dot)org
********************************************************