Thread: Can't connect to my postgresql
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 This probably means the server terminated abnormally before or while processing the request. And on the log file i see: LOG: connection received: host=[local] LOG: connection received: host=[local] LOG: server process (pid 6308) was terminated by signal 11 LOG: terminating any other active server processes LOG: all server processes terminated; reinitializing shared memory and semaphores LOG: database system was interrupted at 2003-03-25 14:58:41 GMT LOG: checkpoint record is at 0/7EBB30 LOG: redo record is at 0/7EBB30; undo record is at 0/0; shutdown TRUE LOG: next transaction id: 480; next oid: 16886 LOG: database system was not properly shut down; automatic recovery in progress LOG: ReadRecord: record with zero length at 0/7EBB70 LOG: redo is not required LOG: database system is ready I configured using ./configure --prefix=/apps/pgsql-7.3.2 --without-readline --with-openssl=/usr/local/ssl --with-pam Some idea?? -- ******************************************************** 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 ********************************************************
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
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 ********************************************************
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@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 ********************************************************