Thread: Running postmaster with TCP/IP (ipv4)

Running postmaster with TCP/IP (ipv4)

From
"Adham Helal"
Date:
hey

I am a mysql guy, after reading a lot of reviews i decided to convert my co.
to postgresql. I am experimenting with pgsql for a week so far good.

I downloaded pgsql ver 7.4.1 and installed (./configure �with-java) but when
i start postmaster with -i  option i get this error �could not create IPv6
socket: Address family not supported by protocol� and i dont want ipv6 in
the first place. I only want ipv4. I tried to find something to disable ipv6
but i didn't

Where did i go wrong ? or how to fix it ?

My system slackware 9.1/ kernel 2.4.22

Thank you

_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail


Re: Running postmaster with TCP/IP (ipv4)

From
Tom Lane
Date:
"Adham Helal" <aahelal@hotmail.com> writes:
> when i start postmaster with -i option i get this error �could not
> create IPv6 socket: Address family not supported by protocol� and i
> dont want ipv6 in the first place. I only want ipv4. I tried to find
> something to disable ipv6 but i didn't

This isn't really an error, and you can safely ignore it.  The reason
you see it is that getaddrinfo() is returning an IPv6 address as well as
an IPv4 address for "localhost".  Postgres tries to bind to both (as I
think it should), but your kernel isn't configured to support IPv6 so
it bounces that attempt.  The IPv4 try succeeds so Postgres is happy.

If you don't like seeing the message in your logs, the solution is to
get glibc and the kernel on the same page --- either both supporting
IPv6 or both not.  I am not sure where exactly you configure what
getaddrinfo will translate "localhost" to; possibly /etc/hosts or your
DNS setup, but I've not worked with an IPv6-enabled system myself.
Anyway that's what you need to change.

            regards, tom lane