Skip site navigation (1) Skip section navigation (2)

Re: Problem connecting to localhost in 7.4.2

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Shawn Kovalchick <bamapookie(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Problem connecting to localhost in 7.4.2
Date: 2004-10-31 16:46:48
Message-ID: 418516F8.9070109@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-admin
>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
>  
>
Perhaps your default firewall set up in FC2 is blocking 5432 to localhost?
What does your /sbin/iptables -L say?


Sincerely,

Joshua D. Drake


>http://pookie.dyndns.org/strace-psql.txt
>Thank you in advance for your help.
>  
>
>------------------------------------------------------------------------
>
>[root(at)conops2 log]# strace -frp 3526
>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.000133 --- SIGCHLD (Child exited) @ 0 (0) ---
>     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]     59.996233 --- SIGALRM (Alarm clock) @ 0 (0) ---
>[pid  3686]      0.000800 exit_group(0) = ?
>Process 3686 detached
>     0.000761 <... select resumed> )    = ? ERESTARTNOHAND (To be restarted)
>     0.000524 --- SIGCHLD (Child exited) @ 0 (0) ---
>     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
>    (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>  
>


-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL


Attachment: jd.vcf
Description: text/x-vcard (285 bytes)

In response to

pgsql-admin by date

Next:From: IainDate: 2004-11-01 01:45:46
Subject: Re: pg_restore error
Previous:From: Tom LaneDate: 2004-10-31 16:43:35
Subject: Re: Problem connecting to localhost in 7.4.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group