Applied. ---------------------------------------------------------------------------
Chris Browne wrote: > [EMAIL PROTECTED]:/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 "[EMAIL PROTECTED]" "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 [EMAIL PROTECTED] 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. + ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings