Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 95CA79FB1F8 for ; Mon, 27 Nov 2006 02:27:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 61674-06 for ; Mon, 27 Nov 2006 02:27:08 -0400 (AST) X-Greylist: delayed 01:00:00.412304 by SQLgrey-1.7.4 Received: from shakespeare-nyc.com (mailhost.shakespeare-nyc.com [67.154.66.2]) by postgresql.org (Postfix) with ESMTP id 06F629FB1CF for ; Mon, 27 Nov 2006 02:27:08 -0400 (AST) Received: from [10.0.12.1] (account bill [10.0.12.1] verified) by shakespeare-nyc.com (CommuniGate Pro SMTP 5.1c.4) with ESMTPA id 17028495; Mon, 27 Nov 2006 00:27:07 -0500 Message-ID: <456A772A.4060209@shakespeare-nyc.com> Date: Mon, 27 Nov 2006 00:27:06 -0500 From: Bill Kurland User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 To: Tom Lane CC: pgsql-general@postgresql.org Subject: Re: Upgrade problem References: <456388BF.2030504@panix.com> <22062.1164167046@sss.pgh.pa.us> In-Reply-To: <22062.1164167046@sss.pgh.pa.us> Content-Type: multipart/alternative; boundary="------------000900080000040309060305" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/1460 X-Sequence-Number: 104555 This is a multi-part message in MIME format. --------------000900080000040309060305 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Tom: Thanks for the reply. I've installed the patch and, as you predicted, it had no effect. I did a google search on AIX + getaddrinfo and found > http://lists.samba.org/archive/rsync/2002-April/002063.html In that context the author says that adding the port number in etc/services solved his problem with getaddrinfo. So I tried that and, lo, it has some effect, though I'm not sure it's 100% desirable. The log entry is: LOG: could not bind IPv6 socket: The type of socket is not supported in this protocol family. HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry. LOG: database system was shut down at 2006-11-26 23:26:32 EST LOG: checkpoint record is at 0/38D198 LOG: redo record is at 0/38D198; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 565; next OID: 10793 LOG: next MultiXactId: 1; next MultiXactOffset: 0 LOG: database system is ready LOG: transaction ID wrap limit is 2147484146, limited by database "postgres" but postmaster is running. I've restored my database and a cursory look seems to show everything is working as expected. Can you tell me what the log entries signify? Thanks again. Tom Lane wrote: > Bill Kurland writes: > >> I've just upgraded from 7.2 to 8.1.5 under AIX 4.3. >> make check passes all 98 tests, but when I try to start postgresql I get: >> > > >> LOG: could not translate service "5432" to address: Host not found >> > > Hmm, this seems to be another one of those "AIX's getaddrinfo() is > broken" problems :-(. We patched around one problem last month: > http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/libpq/ip.c.diff?r1=1.32.2.1&r2=1.32.2.3 > > I'm afraid that that patch does not fix your problem, but it would be > worth trying it before we dig any deeper. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > > -- Bill Kurland Shakespeare & Co. 138 Watts Street New York, NY 10013 212-965-9683 212-965-9684 Fax -- Can I now congratulate the same nation upon its freedom? Is it because liberty in the abstract may be classed amongst the blessings of mankind, that I am seriously to felicitate a madman, who has escaped from the protecting restraint and wholesome darkness of his cell, on his restoration to the enjoyment of light and liberty? Am I to congratulate a highwayman and murderer who has broke prison upon the recovery of his natural rights? -Edmund Burke, "Reflections on the Revolution in France" --------------000900080000040309060305 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Tom:

Thanks for the reply. I've installed the patch and, as you predicted, it had no effect.

I did a google search on AIX + getaddrinfo and found
http://lists.samba.org/archive/rsync/2002-April/002063.html
In that context the author says that adding the port number in etc/services solved his problem with getaddrinfo. So I tried that and, lo, it has some effect, though I'm not sure it's 100% desirable. The log entry is:

LOG:  could not bind IPv6 socket: The type of socket is not supported in this protocol family.
HINT:  Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
LOG:  database system was shut down at 2006-11-26 23:26:32 EST
LOG:  checkpoint record is at 0/38D198
LOG:  redo record is at 0/38D198; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 565; next OID: 10793
LOG:  next MultiXactId: 1; next MultiXactOffset: 0
LOG:  database system is ready
LOG:  transaction ID wrap limit is 2147484146, limited by database "postgres"

but postmaster is running.

I've restored my database and a cursory look seems to show everything is working as expected. Can you tell me what the log entries signify?

Thanks again.



Tom Lane wrote:
Bill Kurland <bill@panix.com> writes:
  
I've just upgraded from 7.2 to 8.1.5 under AIX 4.3.
make check passes all 98 tests, but when I try to start postgresql I get:
    

  
LOG:  could not translate service "5432" to address: Host not found
    

Hmm, this seems to be another one of those "AIX's getaddrinfo() is
broken" problems :-(.  We patched around one problem last month:
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/libpq/ip.c.diff?r1=1.32.2.1&r2=1.32.2.3

I'm afraid that that patch does not fix your problem, but it would be
worth trying it before we dig any deeper.

			regards, tom lane

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

  


-- 

Bill Kurland
Shakespeare & Co.
138 Watts Street
New York, NY 10013

212-965-9683
212-965-9684 Fax 

--
Can I now congratulate the same nation upon its freedom? Is it because liberty in the abstract may be classed amongst the blessings of mankind, that I am seriously to felicitate a madman, who has escaped from the protecting restraint and wholesome darkness of his cell, on his restoration to the enjoyment of light and liberty? Am I to congratulate a highwayman and murderer who has broke prison upon the recovery of his natural rights?
 -Edmund Burke, "Reflections on the Revolution in France" 
--------------000900080000040309060305--