Обсуждение: AIX postgresql error
Hello Guys,
On AIX while starting postgresql server I got this error . But server starts up without any issues.
LOG: could not bind IPv6 socket: Address already in use
HINT: Is another postmaster already running on port 8432? If not, wait a few seconds and retry.
Could you please provide some input to avoid this warning / error ? Though its not harmful but its misleading
Thanks & Regards,
Vikram
Vikram Patil wrote: > On AIX while starting postgresql server I got this error > . But server starts up without any issues. > > LOG: could not bind IPv6 socket: Address already in use > > HINT: Is another postmaster already running on port 8432? If > not, wait a few seconds and retry. > > Could you please provide some input to avoid this warning / > error ? Though its not harmful but its misleading That should only be a problem if you want to use IPv6. Can you connect to the server via network? If yes, then I wouldn't worry about the message. You can avoid the message by specifying an explicit IP address or host name for the IPv4 connection in listen_addresses instead of "*". Yours, Laurenz Albe
Thanks Laurence for Reply. I can actually connect to server using network. I am just trying to avoid this warning. Your solution for listen_address will work but I want to keep it as "*" . Somehow it doesn't complain on any other *nix Operation Systems. Thanks & Regards, Vikram -----Original Message----- From: Albe Laurenz [mailto:laurenz.albe@wien.gv.at] Sent: Friday, March 19, 2010 6:16 AM To: Vikram Patil; pgsql-general@postgresql.org Subject: RE: [GENERAL] AIX postgresql error Vikram Patil wrote: > On AIX while starting postgresql server I got this error > . But server starts up without any issues. > > LOG: could not bind IPv6 socket: Address already in use > > HINT: Is another postmaster already running on port 8432? If > not, wait a few seconds and retry. > > Could you please provide some input to avoid this warning / > error ? Though its not harmful but its misleading That should only be a problem if you want to use IPv6. Can you connect to the server via network? If yes, then I wouldn't worry about the message. You can avoid the message by specifying an explicit IP address or host name for the IPv4 connection in listen_addresses instead of "*". Yours, Laurenz Albe
Vikram Patil wrote: > Thanks Laurence for Reply. > I can actually connect to server using network. I am just trying to > avoid this warning. Your solution for listen_address will work but I > want to keep it as "*" . Somehow it doesn't complain on any other *nix > Operation Systems. Probably IPv6 is set up correctly on the machines where you don't get an error. You can unconfigure IPv6 on the AIX, then PostgreSQL won't try to listen on IPv6 ports. Ask the system administrators of the machine for help. Yours, Laurenz Albe