Is there a parameter to tell postgresql to not attempt to open an IPv6 socket?

Started by Reid Thompsonover 17 years ago5 messagesgeneral
Jump to latest
#1Reid Thompson
Reid.Thompson@ateb.com

Startup of 8.3.3 on AIX is outputting these messages into the logfile...

LOG: could not bind IPv6 socket: The socket name is already in use.
HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.

PostgreSQL appears to all intents to startup fine on the UNIX and IPv4
sockets. Is there a parameter to tell postgresql to not attempt to open
an IPv6 socket?

Thanks,
reid

#2Andrew Sullivan
ajs@commandprompt.com
In reply to: Reid Thompson (#1)
Re: Is there a parameter to tell postgresql to not attempt to open an IPv6 socket?

On Tue, Sep 16, 2008 at 04:46:37PM -0400, Reid.Thompson wrote:

PostgreSQL appears to all intents to startup fine on the UNIX and IPv4
sockets. Is there a parameter to tell postgresql to not attempt to open
an IPv6 socket?

Specify the specific TCP/IP interfaces in the postmaster.conf file.
Otherwise, Postgres will try to bind to all the sockets. There's
something hinkey about the IPv6 support in AIX, IIRC, so that you end
up with this symptom.

A

--
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/

#3Noname
yann.dubost@gmail.com
In reply to: Reid Thompson (#1)
Re: Is there a parameter to tell postgresql to not attempt to open an IPv6 socket?

On 16 sep, 23:04, a...@commandprompt.com (Andrew Sullivan) wrote:

On Tue, Sep 16, 2008 at 04:46:37PM -0400, Reid.Thompson wrote:

PostgreSQL appears to all intents to startup fine on the UNIX and IPv4
sockets.  Is there a parameter to tell postgresql tonotattempt to open
anIPv6socket?

Specify the specific TCP/IP interfaces in the postmaster.conf file.
Otherwise, Postgres will try tobindto all the sockets.  There's
something hinkey about theIPv6support in AIX, IIRC, so that you end
up with this symptom.  

A

--
Andrew Sullivan
a...@commandprompt.com
+1 503 667 4564 x104http://www.commandprompt.com/

--
Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org)
To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general

Hello,

I have the same pb. I have looked for a postmaster.conf file but there
is none on the server.
Apart from the doc and src files, the only files on my server
containing the word "postmaster" are :
/usr/local/pgsql/bin/postmaster
$PGDATA/postmaster.opts
$PGDATA/postmaster.pid

Do you have an idea why and how then to solve this pb ?

Thanks,

Yann.

#4Scott Marlowe
scott.marlowe@gmail.com
In reply to: Noname (#3)
Re: Re: Is there a parameter to tell postgresql to not attempt to open an IPv6 socket?

On Mon, Sep 29, 2008 at 7:41 AM, <yann.dubost@gmail.com> wrote:

On 16 sep, 23:04, a...@commandprompt.com (Andrew Sullivan) wrote:

On Tue, Sep 16, 2008 at 04:46:37PM -0400, Reid.Thompson wrote:

PostgreSQL appears to all intents to startup fine on the UNIX and IPv4
sockets. Is there a parameter to tell postgresql tonotattempt to open
anIPv6socket?

Specify the specific TCP/IP interfaces in the postmaster.conf file.
Otherwise, Postgres will try tobindto all the sockets. There's
something hinkey about theIPv6support in AIX, IIRC, so that you end
up with this symptom.

Hello,

I have the same pb. I have looked for a postmaster.conf file but there
is none on the server.
Apart from the doc and src files, the only files on my server
containing the word "postmaster" are :
/usr/local/pgsql/bin/postmaster
$PGDATA/postmaster.opts
$PGDATA/postmaster.pid

Do you have an idea why and how then to solve this pb ?

Look for postgresql.conf

#5Andrew Sullivan
ajs@commandprompt.com
In reply to: Noname (#3)
Re: Re: Is there a parameter to tell postgresql to not attempt to open an IPv6 socket?

On Mon, Sep 29, 2008 at 06:41:33AM -0700, yann.dubost@gmail.com wrote:

On 16 sep, 23:04, a...@commandprompt.com (Andrew Sullivan) wrote:

Specify the specific TCP/IP interfaces in the postmaster.conf file.

I have the same pb. I have looked for a postmaster.conf file but there

Doh! Sorry, that should have been "postgresql.conf".

A

--
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/