From: Daniel Rubio <drubior@tinet.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Can't connect to my postgresql
Date: Wed, 26 Mar 2003 08:49:15 +0100
Message-ID: <3E815B7B.5000401@tinet.org> (raw)
References: <3E8061A0.5010805@tinet.org>
<28425.1048603338@sss.pgh.pa.us>
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@tinet.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@oasi.org
********************************************************
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: drubior@tinet.org, tgl@sss.pgh.pa.us, pgsql-admin@postgresql.org
Subject: Re: Can't connect to my postgresql
In-Reply-To: <3E815B7B.5000401@tinet.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox