X-Original-To: pgsql-admin@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 442A4475EC9 for ; Wed, 26 Mar 2003 02:49:43 -0500 (EST) Received: from nil.tinet.org (tinet.org [195.77.216.130]) by postgresql.org (Postfix) with ESMTP id 0CB32475D91 for ; Wed, 26 Mar 2003 02:49:42 -0500 (EST) Received: from tinet.org ([195.76.233.3]) by nil.tinet.org (Netscape Messaging Server 4.1) with ESMTP id HCCJ2T03.104; Wed, 26 Mar 2003 08:49:41 +0100 Message-ID: <3E815B7B.5000401@tinet.org> Date: Wed, 26 Mar 2003 08:49:15 +0100 From: Daniel Rubio User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.2) Gecko/20021120 Netscape/7.01 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: pgsql-admin Subject: Re: Can't connect to my postgresql References: <3E8061A0.5010805@tinet.org> <28425.1048603338@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-35.6 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,QUOTED_EMAIL_TEXT,REFERENCES, REPLY_WITH_QUOTES,USER_AGENT_MOZILLA_UA autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/433 X-Sequence-Number: 8073 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:=20 /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,=20 2d0ea3) + 2c 00122c70 recv_and_check_password_packet (33d558, 3, 0, ffffffff,=20 fffffff8, ffbeffc1) + f0 001223f4 ClientAuthentication (33d558, 33d648, 2b4198, fefbc004,=20 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,=20 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 writes: >=20 >>I've recently installed postgres in a new computer running solaris 8,=20 >>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 >=20 >=20 > Can you provide a debugger stack trace? This should be leaving a core > dump file in the database subdirectory ($PGDATA/base/something/core). >=20 > regards, tom lane >=20 >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? >=20 > http://www.postgresql.org/docs/faqs/FAQ.html >=20 --=20 ******************************************************** Daniel Rubio Rodr=EDguez OASI (Organisme Aut=F2nom Per la Societat de la Informaci=F3) c/ Assalt, 12 43003 - Tarragona Tef.: 977.244.007 - Fax: 977.224.517 e-mail: drubio@oasi.org ********************************************************