X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1218E9FACFE for ; Fri, 16 Jun 2006 00:12:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 97083-01 for ; Fri, 16 Jun 2006 00:11:40 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from weatherbeeta.com.au (mail.weatherbeeta.com.au [202.154.127.242]) by postgresql.org (Postfix) with SMTP id 197DC9FA160 for ; Fri, 16 Jun 2006 00:11:39 -0300 (ADT) Received: (qmail 12044 invoked from network); 16 Jun 2006 03:11:38 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;d675067faa814d28d9bead8f2281d5fd; Received: from mail.weatherbeeta.com.au (HELO wb-email) (172.20.0.2)by network-box.weatherbeeta.com.au with SMTP; 16 Jun 2006 03:11:38 -0000 Received: from IT-PHIL ([172.20.0.155]) by wb-email (602Pro LAN SUITE 2003) id 2d5340ab for pgsql-sql@postgresql.org; Fri, 16 Jun 2006 13:09:50 +1000 Reply-To: From: "Phillip Smith" Cc: Subject: Re: listen_addresses = '*' ok, specific address(es) no (.... and a thread hi-jack!) Date: Fri, 16 Jun 2006 13:11:23 +1000 Organization: Weatherbeeta P/L Message-ID: <005501c690f2$8c9c59a0$9b0014ac@ITPhil> MIME-Version: 1.0 Content-Type: text/plain;charset="US-ASCII" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 In-Reply-To: <12321.1150427069@sss.pgh.pa.us> X-Scanned-By-wbeetaau1: Virus scan performed by network-box X-Scanned-By-wbeetaau1: Scanner file id is wbeetaau1-1150427498.590-12039-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.02/0.07 secs) X-Scanned-By-wbeetaau1: Spam-Check-Result: No, hits=0 required=7 tests= autolearn=no version=2.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/198 X-Sequence-Number: 25434 Dang - Our NZ operations are a lot smaller than ours. They only have the = one Linux server and it's primary role is to run the D3 gear I was talking = about the other day - same in Australia!! I am trying to get the number = crunchers to fork out the $$$ for RH ES4 and a nice new server. Thanks Tom, I'll put up with the errors for now until I can get them a = new server. -p -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20 Sent: Friday, 16 June 2006 1:04 PM To: phillips@weatherbeeta.com.au Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] listen_addresses =3D '*' ok, specific address(es) no = (.... and a thread hi-jack!)=20 "Phillip Smith" writes: > > I've just installed Postgres 8.1 on RedHat 7.1 Uh ... *why*? I wouldn't use RH 7.1 today any more than I'd use PG 7.1 = ... > and I'm getting the error: > "2006-06-16 14:49:00 NZST @ []LOG: could not create IPv6 socket: = Address > family not supported by protocol" It seems you've got libc code that supports IPv6 even though your kernel does not (else PG would not have been told that an IPv6 address was a possible translation of "localhost"). PG copes with this but will issue LOG messages complaining about it. If you don't like the warnings, fix your system so it's all on the same page about whether IPv6 is = supported. regards, tom lane *******************Confidentiality and Privilege Notice******************* The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email. Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments