X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D30FD3A3C5A for ; Sat, 30 Oct 2004 00:45:23 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 21634-04 for ; Fri, 29 Oct 2004 23:45:11 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.192]) by svr1.postgresql.org (Postfix) with ESMTP id AECF03A3C59 for ; Sat, 30 Oct 2004 00:45:12 +0100 (BST) Received: by wproxy.gmail.com with SMTP id 68so1423wri for ; Fri, 29 Oct 2004 16:44:56 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type; b=e8+4OV+oilfnRA0IPu5g5P0zVaEVbj/gypkMrlAVq5MrOeqjCSafS1rLFW+esIT3NWBCOS1RbTi035TxNvKlOmbcBH5xlCCj68qr9gYWpWPDzHjbfdhM2KNivu0ljtGdLE9q6f/BaDyOf3oKuRBNW2XpDYsVmOWzptDxgbr5GIA= Received: by 10.38.73.43 with SMTP id v43mr1242794rna; Fri, 29 Oct 2004 16:44:55 -0700 (PDT) Received: by 10.38.75.11 with HTTP; Fri, 29 Oct 2004 16:44:55 -0700 (PDT) Message-ID: Date: Fri, 29 Oct 2004 19:44:55 -0400 From: Shawn Kovalchick Reply-To: Shawn Kovalchick To: pgsql-admin@postgresql.org Subject: Problem connecting to localhost in 7.4.2 Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_Part_1447_20530600.1099093495902" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/389 X-Sequence-Number: 15382 ------=_Part_1447_20530600.1099093495902 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline I am setting up a postgres server on Redhat Fedora Core 2, and am unable to connect via tcpip. I have enabled tcpip_socket in postgresql.conf. For testing prposes, I'm using trust for local and host 127.0.0.1 in pg_hba.conf. The command I am running is: psql -h 127.0.0.1 nagios Username is shawn This works if I leave off the -h 127.0.0.1. Attached is the strace for postmaster. The strace for psql is too big for the email list, so it is posted at http://pookie.dyndns.org/strace-psql.txt Thank you in advance for your help. ------=_Part_1447_20530600.1099093495902 Content-Type: text/plain; name="strace-postmaster.txt" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="strace-postmaster.txt" [root@conops2 log]# strace -frp 3526 Process 3526 attached - interrupt to quit 0.000000 select(6, [3 4 5], NULL, NULL, {1, 445000}) =3D 0 (Timeout) 1.446027 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT= SYS RTMIN], NULL, 8) =3D 0 0.000217 time(NULL) =3D 1099092340 0.000147 clone(Process 3683 attached child_stack=3D0, flags=3DCLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, c= hild_tidptr=3D0xf70df748) =3D 3683 [pid 3526] 0.000920 utime("/tmp/.s.PGSQL.5432", NULL [pid 3683] 0.000124 close(3 [pid 3526] 0.000189 <... utime resumed> ) =3D 0 [pid 3683] 0.000068 <... close resumed> ) =3D 0 [pid 3526] 0.000070 utime("/tmp/.s.PGSQL.5432.lock", NULL [pid 3683] 0.000142 close(4) =3D 0 [pid 3683] 0.000097 close(5) =3D 0 [pid 3683] 0.000095 close(7) =3D 0 [pid 3683] 0.000113 close(8) =3D 0 [pid 3526] 0.000318 <... utime resumed> ) =3D 0 [pid 3526] 0.000209 rt_sigprocmask(SIG_SETMASK, [], [pid 3683] 0.000090 open("/var/lib/pgsql/data/PG_VERSION", O_RDONLY|O= _LARGEFILE) =3D 3 [pid 3526] 0.000226 <... rt_sigprocmask resumed> NULL, 8) =3D 0 [pid 3683] 0.000084 fstat64(3, [pid 3526] 0.000080 select(6, [3 4 5], NULL, NULL, {60, 0} [pid 3683] 0.000228 <... fstat64 resumed> {st_mode=3DS_IFREG|0600, st= _size=3D4, ...}) =3D 0 [pid 3683] 0.000213 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVA= TE|MAP_ANONYMOUS, -1, 0) =3D 0xf64c7000 [pid 3683] 0.000145 read(3, "7.4\n", 4096) =3D 4 [pid 3683] 0.000216 close(3) =3D 0 [pid 3683] 0.000106 munmap(0xf64c7000, 4096) =3D 0 [pid 3683] 0.000127 rt_sigaction(SIGHUP, {SIG_IGN}, {0x8157600, [], S= A_RESTART}, 8) =3D 0 [pid 3683] 0.000166 rt_sigaction(SIGINT, {SIG_IGN}, {0x81576d0, [], S= A_RESTART}, 8) =3D 0 [pid 3683] 0.000162 rt_sigaction(SIGTERM, {0x817dd50, [], SA_RESTART}= , {0x81576d0, [], SA_RESTART}, 8) =3D 0 [pid 3683] 0.000166 rt_sigaction(SIGQUIT, {0x817dca0, [], SA_RESTART}= , {0x81576d0, [], SA_RESTART}, 8) =3D 0 [pid 3683] 0.000180 rt_sigaction(SIGALRM, {SIG_IGN}, {SIG_IGN}, 8) = =3D 0 [pid 3683] 0.000153 rt_sigaction(SIGPIPE, {SIG_IGN}, {SIG_IGN}, 8) = =3D 0 [pid 3683] 0.000151 rt_sigaction(SIGUSR1, {SIG_IGN}, {0x8158cb0, [], = SA_RESTART}, 8) =3D 0 [pid 3683] 0.000158 rt_sigaction(SIGUSR2, {SIG_IGN}, {0x8158e40, [], = SA_RESTART}, 8) =3D 0 [pid 3683] 0.000165 rt_sigaction(SIGCHLD, {SIG_DFL}, {0x8157a60, [], = SA_RESTART}, 8) =3D 0 [pid 3683] 0.000158 rt_sigaction(SIGTTIN, {SIG_DFL}, {SIG_IGN}, 8) = =3D 0 [pid 3683] 0.000188 rt_sigaction(SIGTTOU, {SIG_DFL}, {SIG_IGN}, 8) = =3D 0 [pid 3683] 0.000152 rt_sigaction(SIGCONT, {SIG_DFL}, {SIG_DFL}, 8) = =3D 0 [pid 3683] 0.000152 rt_sigaction(SIGWINCH, {SIG_DFL}, {SIG_DFL}, 8) = =3D 0 [pid 3683] 0.000152 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) =3D 0 [pid 3683] 0.000315 semctl(3473447, 4, IPC_64|SETVAL, 0xfeea7a34) =3D= 0 [pid 3683] 0.000358 time(NULL) =3D 1099092340 [pid 3683] 0.000770 exit_group(0) =3D ? Process 3683 detached 0.000709 <... select resumed> ) =3D ? ERESTARTNOHAND (To be restart= ed) 0.000133 --- SIGCHLD (Child exited) @ 0 (0) --- 0.000187 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT= SYS RTMIN], NULL, 8) =3D 0 0.000308 waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) =3D=3D 0}], WNOH= ANG) =3D 3683 0.000286 time(NULL) =3D 1099092340 0.000269 waitpid(-1, 0xfeea789c, WNOHANG) =3D 0 0.000117 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) =3D 0 0.000121 sigreturn() =3D ? (mask now []) 0.000204 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT= SYS RTMIN], NULL, 8) =3D 0 0.000141 time(NULL) =3D 1099092340 0.000117 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) =3D 0 0.000128 select(6, [3 4 5], NULL, NULL, {300, 0}) =3D 1 (in [4], left = {297, 849000}) 2.150629 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT= SYS RTMIN], NULL, 8) =3D 0 0.000177 accept(4, {sa_family=3DAF_INET, sin_port=3Dhtons(32825), sin_= addr=3Dinet_addr("127.0.0.1")}, [16]) =3D 9 0.000431 getsockname(9, {sa_family=3DAF_INET, sin_port=3Dhtons(5432), = sin_addr=3Dinet_addr("127.0.0.1")}, [16]) =3D 0 0.000454 setsockopt(9, SOL_TCP, TCP_NODELAY, [1], 4) =3D 0 0.000285 setsockopt(9, SOL_SOCKET, SO_KEEPALIVE, [1], 4) =3D 0 0.000147 clone(Process 3686 attached child_stack=3D0, flags=3DCLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, c= hild_tidptr=3D0xf70df748) =3D 3686 [pid 3526] 0.001056 close(9 [pid 3686] 0.000162 close(3 [pid 3526] 0.000062 <... close resumed> ) =3D 0 [pid 3686] 0.000072 <... close resumed> ) =3D 0 [pid 3686] 0.000062 close(4) =3D 0 [pid 3686] 0.000106 close(5) =3D 0 [pid 3526] 0.000114 time( [pid 3686] 0.000062 close(7) =3D 0 [pid 3686] 0.000113 close(8) =3D 0 [pid 3686] 0.000179 rt_sigaction(SIGTERM, {0x817dde0, [], SA_RESTART}= , [pid 3526] 0.000105 <... time resumed> NULL) =3D 1099092342 [pid 3686] 0.000064 <... rt_sigaction resumed> {0x81576d0, [], SA_RES= TART}, 8) =3D 0 [pid 3686] 0.000105 rt_sigaction(SIGQUIT, {0x817dde0, [], SA_RESTART}= , [pid 3526] 0.000110 rt_sigprocmask(SIG_SETMASK, [], [pid 3686] 0.000083 <... rt_sigaction resumed> {0x81576d0, [], SA_RES= TART}, 8) =3D 0 [pid 3686] 0.000104 rt_sigaction(SIGALRM, {0x817dde0, [], 0}, [pid 3526] 0.000090 <... rt_sigprocmask resumed> NULL, 8) =3D 0 [pid 3686] 0.000060 <... rt_sigaction resumed> {SIG_IGN}, 8) =3D 0 [pid 3526] 0.000098 select(6, [3 4 5], NULL, NULL, {298, 0} [pid 3686] 0.000224 rt_sigprocmask(SIG_SETMASK, ~[QUIT ILL TRAP ABRT = BUS FPE SEGV ALRM TERM CONT SYS RTMIN], NULL, 8) =3D 0 [pid 3686] 0.000372 socket(PF_FILE, SOCK_DGRAM, 0) =3D 3 [pid 3686] 0.000301 fcntl64(3, F_SETFD, FD_CLOEXEC) =3D 0 [pid 3686] 0.000315 connect(3, {sa_family=3DAF_FILE, path=3D"/dev/log= "}, 16) =3D 0 [pid 3686] 0.000381 time([1099092342]) =3D 1099092342 [pid 3686] 0.000343 rt_sigaction(SIGPIPE, {0x36e450, [], 0}, {SIG_IGN= }, 8) =3D 0 [pid 3686] 0.000339 send(3, "<134>Oct 29 19:25:42 postgres[36"..., 95= , 0) =3D 95 [pid 3686] 0.000304 rt_sigaction(SIGPIPE, {SIG_IGN}, NULL, 8) =3D 0 [pid 3686] 0.000168 write(2, "LOG: connection received: host=3D"...,= 53) =3D 53 [pid 3686] 0.000189 setitimer(ITIMER_REAL, {it_interval=3D{0, 0}, it_= value=3D{60, 0}}, NULL) =3D 0 [pid 3686] 0.000196 recv(9, "\0\0\0\10\4\322\26/", 8192, 0) =3D 8 [pid 3686] 0.000212 send(9, "N", 1, 0) =3D 1 [pid 3686] 0.000685 recv(9, "\0\0\0$\0\3\0\0user\0shawn\0database\0na= gi"..., 8192, 0) =3D 36 [pid 3686] 0.000854 socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) =3D 4 [pid 3686] 0.000152 connect(4, {sa_family=3DAF_INET, sin_port=3Dhtons= (0), sin_addr=3Dinet_addr("127.0.0.1")}, 16) =3D 0 [pid 3686] 0.000214 getsockname(4, {sa_family=3DAF_INET, sin_port=3Dh= tons(32776), sin_addr=3Dinet_addr("127.0.0.1")}, [16]) =3D 0 [pid 3686] 0.000252 close(4) =3D 0 [pid 3686] 0.000135 socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) =3D 4 [pid 3686] 0.000127 connect(4, {sa_family=3DAF_INET, sin_port=3Dhtons= (0), sin_addr=3Dinet_addr("127.0.0.1")}, 16) =3D 0 [pid 3686] 0.000148 getsockname(4, {sa_family=3DAF_INET, sin_port=3Dh= tons(32776), sin_addr=3Dinet_addr("127.0.0.1")}, [16]) =3D 0 [pid 3686] 0.000256 close(4) =3D 0 [pid 3686] 0.000120 socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) =3D 4 [pid 3686] 0.000126 connect(4, {sa_family=3DAF_INET, sin_port=3Dhtons= (0), sin_addr=3Dinet_addr("127.0.0.1")}, 16) =3D 0 [pid 3686] 0.000153 getsockname(4, {sa_family=3DAF_INET, sin_port=3Dh= tons(32776), sin_addr=3Dinet_addr("127.0.0.1")}, [16]) =3D 0 [pid 3686] 0.000241 close(4) =3D 0 [pid 3686] 59.996233 --- SIGALRM (Alarm clock) @ 0 (0) --- [pid 3686] 0.000800 exit_group(0) =3D ? Process 3686 detached 0.000761 <... select resumed> ) =3D ? ERESTARTNOHAND (To be restart= ed) 0.000524 --- SIGCHLD (Child exited) @ 0 (0) --- 0.000117 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT= SYS RTMIN], NULL, 8) =3D 0 0.000169 waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) =3D=3D 0}], WNOH= ANG) =3D 3686 0.000287 send(6, "\2\0\0\0\30\0\0\0\0\0\0\0f\16\0\0\0\0\0\0\0\0\0\0", = 24, 0) =3D 24 0.000650 waitpid(-1, 0xfeea789c, WNOHANG) =3D 0 0.000121 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) =3D 0 0.000117 sigreturn() =3D ? (mask now []) 0.000406 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT= SYS RTMIN], NULL, 8) =3D 0 0.000224 time(NULL) =3D 1099092402 0.000125 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) =3D 0 0.000126 select(6, [3 4 5], NULL, NULL, {238, 0} Process 3526 detached ------=_Part_1447_20530600.1099093495902--