pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shawn Kovalchick <bamapookie@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Problem connecting to localhost in 7.4.2
Date: Sun, 31 Oct 2004 10:44:54 -0500
Message-ID: <c12dcfbb041031074423875141@mail.gmail.com> (raw)
In-Reply-To: <c12dcfbb04102916442ebbd683@mail.gmail.com>
References: <c12dcfbb04102916442ebbd683@mail.gmail.com>

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.

Attachments:

strace-postmaster.txt (text/plain, 8.7K) download [root@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

view thread (4+ messages)  latest in thread

Message-ID: <c12dcfbb041031074423875141@mail.gmail.com>
Permalink:  ../c12dcfbb041031074423875141@mail.gmail.com/
Also on:    postgresql.org/message-id/c12dcfbb041031074423875141@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: bamapookie@gmail.com
  Subject: Re: Problem connecting to localhost in 7.4.2
  In-Reply-To: <c12dcfbb041031074423875141@mail.gmail.com>
  References: <c12dcfbb04102916442ebbd683@mail.gmail.com> <c12dcfbb041031074423875141@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox