Problem connecting to localhost in 7.4.2

[Shawn Kovalchick]

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.

[Shawn Kovalchick]

I apologize if this gets posted twice, I sent it once before I was
signed up, and it hasn't appeared yet.

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.

[Tom Lane]

Post by Shawn Kovalchick
I am setting up a postgres server on Redhat Fedora Core 2, and am
unable to connect via tcpip.

The trace looks like it's timing out while attempting to do a DNS
lookup on the client IP address (ie, 127.0.0.1). This suggests some
misconfiguration in your local DNS arrangements.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Joshua D. Drake]

Post by Shawn Kovalchick
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

Perhaps your default firewall set up in FC2 is blocking 5432 to localhost?
What does your /sbin/iptables -L say?


Sincerely,

Joshua D. Drake

Post by Shawn Kovalchick
http://pookie.dyndns.org/strace-psql.txt
Thank you in advance for your help.
------------------------------------------------------------------------
Process 3526 attached - interrupt to quit
0.000000 select(6, [3 4 5], NULL, NULL, {1, 445000}) = 0 (Timeout)
1.446027 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN], NULL, 8) = 0
0.000217 time(NULL) = 1099092340
0.000147 clone(Process 3683 attached
child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xf70df748) = 3683
[pid 3526] 0.000920 utime("/tmp/.s.PGSQL.5432", NULL <unfinished ...>
[pid 3683] 0.000124 close(3 <unfinished ...>
[pid 3526] 0.000189 <... utime resumed> ) = 0
[pid 3683] 0.000068 <... close resumed> ) = 0
[pid 3526] 0.000070 utime("/tmp/.s.PGSQL.5432.lock", NULL <unfinished ...>
[pid 3683] 0.000142 close(4) = 0
[pid 3683] 0.000097 close(5) = 0
[pid 3683] 0.000095 close(7) = 0
[pid 3683] 0.000113 close(8) = 0
[pid 3526] 0.000318 <... utime resumed> ) = 0
[pid 3526] 0.000209 rt_sigprocmask(SIG_SETMASK, [], <unfinished ...>
[pid 3683] 0.000090 open("/var/lib/pgsql/data/PG_VERSION", O_RDONLY|O_LARGEFILE) = 3
[pid 3526] 0.000226 <... rt_sigprocmask resumed> NULL, 8) = 0
[pid 3683] 0.000084 fstat64(3, <unfinished ...>
[pid 3526] 0.000080 select(6, [3 4 5], NULL, NULL, {60, 0} <unfinished ...>
[pid 3683] 0.000228 <... fstat64 resumed> {st_mode=S_IFREG|0600, st_size=4, ...}) = 0
[pid 3683] 0.000213 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xf64c7000
[pid 3683] 0.000145 read(3, "7.4\n", 4096) = 4
[pid 3683] 0.000216 close(3) = 0
[pid 3683] 0.000106 munmap(0xf64c7000, 4096) = 0
[pid 3683] 0.000127 rt_sigaction(SIGHUP, {SIG_IGN}, {0x8157600, [], SA_RESTART}, 8) = 0
[pid 3683] 0.000166 rt_sigaction(SIGINT, {SIG_IGN}, {0x81576d0, [], SA_RESTART}, 8) = 0
[pid 3683] 0.000162 rt_sigaction(SIGTERM, {0x817dd50, [], SA_RESTART}, {0x81576d0, [], SA_RESTART}, 8) = 0
[pid 3683] 0.000166 rt_sigaction(SIGQUIT, {0x817dca0, [], SA_RESTART}, {0x81576d0, [], SA_RESTART}, 8) = 0
[pid 3683] 0.000180 rt_sigaction(SIGALRM, {SIG_IGN}, {SIG_IGN}, 8) = 0
[pid 3683] 0.000153 rt_sigaction(SIGPIPE, {SIG_IGN}, {SIG_IGN}, 8) = 0
[pid 3683] 0.000151 rt_sigaction(SIGUSR1, {SIG_IGN}, {0x8158cb0, [], SA_RESTART}, 8) = 0
[pid 3683] 0.000158 rt_sigaction(SIGUSR2, {SIG_IGN}, {0x8158e40, [], SA_RESTART}, 8) = 0
[pid 3683] 0.000165 rt_sigaction(SIGCHLD, {SIG_DFL}, {0x8157a60, [], SA_RESTART}, 8) = 0
[pid 3683] 0.000158 rt_sigaction(SIGTTIN, {SIG_DFL}, {SIG_IGN}, 8) = 0
[pid 3683] 0.000188 rt_sigaction(SIGTTOU, {SIG_DFL}, {SIG_IGN}, 8) = 0
[pid 3683] 0.000152 rt_sigaction(SIGCONT, {SIG_DFL}, {SIG_DFL}, 8) = 0
[pid 3683] 0.000152 rt_sigaction(SIGWINCH, {SIG_DFL}, {SIG_DFL}, 8) = 0
[pid 3683] 0.000152 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
[pid 3683] 0.000315 semctl(3473447, 4, IPC_64|SETVAL, 0xfeea7a34) = 0
[pid 3683] 0.000358 time(NULL) = 1099092340
[pid 3683] 0.000770 exit_group(0) = ?
Process 3683 detached
0.000709 <... select resumed> ) = ? ERESTARTNOHAND (To be restarted)
0.000187 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN], NULL, 8) = 0
0.000308 waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG) = 3683
0.000286 time(NULL) = 1099092340
0.000269 waitpid(-1, 0xfeea789c, WNOHANG) = 0
0.000117 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
0.000121 sigreturn() = ? (mask now [])
0.000204 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN], NULL, 8) = 0
0.000141 time(NULL) = 1099092340
0.000117 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
0.000128 select(6, [3 4 5], NULL, NULL, {300, 0}) = 1 (in [4], left {297, 849000})
2.150629 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN], NULL, 8) = 0
0.000177 accept(4, {sa_family=AF_INET, sin_port=htons(32825), sin_addr=inet_addr("127.0.0.1")}, [16]) = 9
0.000431 getsockname(9, {sa_family=AF_INET, sin_port=htons(5432), sin_addr=inet_addr("127.0.0.1")}, [16]) = 0
0.000454 setsockopt(9, SOL_TCP, TCP_NODELAY, [1], 4) = 0
0.000285 setsockopt(9, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
0.000147 clone(Process 3686 attached
child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xf70df748) = 3686
[pid 3526] 0.001056 close(9 <unfinished ...>
[pid 3686] 0.000162 close(3 <unfinished ...>
[pid 3526] 0.000062 <... close resumed> ) = 0
[pid 3686] 0.000072 <... close resumed> ) = 0
[pid 3686] 0.000062 close(4) = 0
[pid 3686] 0.000106 close(5) = 0
[pid 3526] 0.000114 time( <unfinished ...>
[pid 3686] 0.000062 close(7) = 0
[pid 3686] 0.000113 close(8) = 0
[pid 3686] 0.000179 rt_sigaction(SIGTERM, {0x817dde0, [], SA_RESTART}, <unfinished ...>
[pid 3526] 0.000105 <... time resumed> NULL) = 1099092342
[pid 3686] 0.000064 <... rt_sigaction resumed> {0x81576d0, [], SA_RESTART}, 8) = 0
[pid 3686] 0.000105 rt_sigaction(SIGQUIT, {0x817dde0, [], SA_RESTART}, <unfinished ...>
[pid 3526] 0.000110 rt_sigprocmask(SIG_SETMASK, [], <unfinished ...>
[pid 3686] 0.000083 <... rt_sigaction resumed> {0x81576d0, [], SA_RESTART}, 8) = 0
[pid 3686] 0.000104 rt_sigaction(SIGALRM, {0x817dde0, [], 0}, <unfinished ...>
[pid 3526] 0.000090 <... rt_sigprocmask resumed> NULL, 8) = 0
[pid 3686] 0.000060 <... rt_sigaction resumed> {SIG_IGN}, 8) = 0
[pid 3526] 0.000098 select(6, [3 4 5], NULL, NULL, {298, 0} <unfinished ...>
[pid 3686] 0.000224 rt_sigprocmask(SIG_SETMASK, ~[QUIT ILL TRAP ABRT BUS FPE SEGV ALRM TERM CONT SYS RTMIN], NULL, 8) = 0
[pid 3686] 0.000372 socket(PF_FILE, SOCK_DGRAM, 0) = 3
[pid 3686] 0.000301 fcntl64(3, F_SETFD, FD_CLOEXEC) = 0
[pid 3686] 0.000315 connect(3, {sa_family=AF_FILE, path="/dev/log"}, 16) = 0
[pid 3686] 0.000381 time([1099092342]) = 1099092342
[pid 3686] 0.000343 rt_sigaction(SIGPIPE, {0x36e450, [], 0}, {SIG_IGN}, 8) = 0
[pid 3686] 0.000339 send(3, "<134>Oct 29 19:25:42 postgres[36"..., 95, 0) = 95
[pid 3686] 0.000304 rt_sigaction(SIGPIPE, {SIG_IGN}, NULL, 8) = 0
[pid 3686] 0.000168 write(2, "LOG: connection received: host="..., 53) = 53
[pid 3686] 0.000189 setitimer(ITIMER_REAL, {it_interval={0, 0}, it_value={60, 0}}, NULL) = 0
[pid 3686] 0.000196 recv(9, "\0\0\0\10\4\322\26/", 8192, 0) = 8
[pid 3686] 0.000212 send(9, "N", 1, 0) = 1
[pid 3686] 0.000685 recv(9, "\0\0\0$\0\3\0\0user\0shawn\0database\0nagi"..., 8192, 0) = 36
[pid 3686] 0.000854 socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 4
[pid 3686] 0.000152 connect(4, {sa_family=AF_INET, sin_port=htons(0), sin_addr=inet_addr("127.0.0.1")}, 16) = 0
[pid 3686] 0.000214 getsockname(4, {sa_family=AF_INET, sin_port=htons(32776), sin_addr=inet_addr("127.0.0.1")}, [16]) = 0
[pid 3686] 0.000252 close(4) = 0
[pid 3686] 0.000135 socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 4
[pid 3686] 0.000127 connect(4, {sa_family=AF_INET, sin_port=htons(0), sin_addr=inet_addr("127.0.0.1")}, 16) = 0
[pid 3686] 0.000148 getsockname(4, {sa_family=AF_INET, sin_port=htons(32776), sin_addr=inet_addr("127.0.0.1")}, [16]) = 0
[pid 3686] 0.000256 close(4) = 0
[pid 3686] 0.000120 socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 4
[pid 3686] 0.000126 connect(4, {sa_family=AF_INET, sin_port=htons(0), sin_addr=inet_addr("127.0.0.1")}, 16) = 0
[pid 3686] 0.000153 getsockname(4, {sa_family=AF_INET, sin_port=htons(32776), sin_addr=inet_addr("127.0.0.1")}, [16]) = 0
[pid 3686] 0.000241 close(4) = 0
[pid 3686] 0.000800 exit_group(0) = ?
Process 3686 detached
0.000761 <... select resumed> ) = ? ERESTARTNOHAND (To be restarted)
0.000117 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN], NULL, 8) = 0
0.000169 waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG) = 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) = 24
0.000650 waitpid(-1, 0xfeea789c, WNOHANG) = 0
0.000121 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
0.000117 sigreturn() = ? (mask now [])
0.000406 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN], NULL, 8) = 0
0.000224 time(NULL) = 1099092402
0.000125 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
0.000126 select(6, [3 4 5], NULL, NULL, {238, 0} <unfinished ...>
Process 3526 detached
------------------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command