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

Re: AIX FAQ - IPv6 Fun

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Chris Browne <cbbrowne(at)acm(dot)org>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: AIX FAQ - IPv6 Fun
Date: 2006-05-26 19:51:12
Message-ID: 200605261951.k4QJpCl01432@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
Applied.

---------------------------------------------------------------------------

Chris Browne wrote:
> cbbrowne(at)dba2:/opt/OXRS/sources/pgsql-HEAD/doc$ cvs diff -u FAQ_AIX 
> Index: FAQ_AIX
> ===================================================================
> RCS file: /projects/cvsroot/pgsql/doc/FAQ_AIX,v
> retrieving revision 1.17
> diff -c -u -r1.17 FAQ_AIX
> cvs diff: conflicting specifications of output style
> --- FAQ_AIX	13 Apr 2006 11:41:02 -0000	1.17
> +++ FAQ_AIX	25 May 2006 21:06:21 -0000
> @@ -365,3 +365,35 @@
>    IBM Redbook
>    http://www.redbooks.ibm.com/redbooks/pdfs/sg245674.pdf
>    http://www.redbooks.ibm.com/abstracts/sg245674.html?Open
> +
> +
> +Statistics Collector Fun on AIX
> +--------------------------------
> +
> +When implementing PostgreSQL version 8.1 on AIX 5.3, we periodically
> +ran into problems where the statistics collector would "mysteriously"
> +not come up successfully.
> +
> +This appears to be the result of unexpected behaviour in the IPv6
> +implementation.  It looks like PostgreSQL and IPv6 do not play very
> +well together at this time on AIX.
> +
> +Any of the following actions "fix" the problem.
> +
> +1.  Delete the localhost ipv6 address
> +
> +(as root)
> +# ifconfig lo0 inet6 ::1/0 delete
> +
> +2.  Remove IPv6 from net services.  The file /etc/netsvc.conf, on AIX,
> +is roughly equivalent to /etc/nsswitch.conf on Solaris/Linux.
> +
> +The default, on AIX, is thus:
> +
> +  hosts=local,bind
> +
> +Replace this with:
> +
> +  hosts=local4,bind4
> +
> +to deactivate searching for IPv6 addresses.
> \ No newline at end of file
> 
> -- 
> (format nil "~S(at)~S" "cbbrowne" "cbbrowne.com")
> http://cbbrowne.com/info/finances.html
> "I once witnessed  a long-winded, month-long flamewar over  the use of
> mice vs. trackballs...It was very silly." -- Matt Welsh
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>        message can get through to the mailing list cleanly
> 

-- 
  Bruce Momjian   http://candle.pha.pa.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

pgsql-patches by date

Next:From: Tom LaneDate: 2006-05-26 19:51:51
Subject: Re: Binary COPY for psql
Previous:From: Tom LaneDate: 2006-05-26 16:43:18
Subject: Re: [HACKERS] BEGIN inside transaction should be an error

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