Re: URGENT : StreamServerPort: bind() failed: Cannotassign

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: sirath(at)cisco(dot)com
Cc: "'Rob'" <pgadmin(at)itsbeen(dot)sent(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: URGENT : StreamServerPort: bind() failed: Cannotassign
Date: 2004-06-04 17:01:00
Message-ID: 3951.1086368460@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Siddharth Rath (sirath)" <sirath(at)cisco(dot)com> writes:
> Surprisingly .s.PGSQL.5432 file is not getting created in /tmp directory ( I believe this should be created).

No, it shouldn't, because that is associated with the creation of the
Unix socket file, which happens after creation of the TCP socket.

Given that you're seeing a kernel error on attempt to create the TCP
socket, I'm convinced that you're wasting your time thinking about
Postgres-internal conditions. This is a kernel-level issue and you
need to be inquiring into what state the kernel is in that is making
it reject the bind().

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message todhunter 2004-06-04 17:02:32 Large database
Previous Message lise chhay 2004-06-04 16:27:55