pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: postmaster: address already in use
2+ messages / 2 participants
[nested] [flat]

* Re: postmaster: address already in use
@ 2001-01-04 07:01  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Markus Wagner <wagner@imsd.uni-mainz.de>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2001-01-04 07:01 UTC (permalink / raw)
  To: Markus Wagner <wagner@imsd.uni-mainz.de>; +Cc: pgsql-sql

Markus Wagner <wagner@imsd.uni-mainz.de> writes:
> my postmaster suddenly begins to make problems. It was running fine, but
> then:
> FATAL: StreamServerPort: bind() failed: Address already in use
>         Is another postmaster already running on that port?
>         If not, remove socket node (/tmp/.s.PGSQL.5432) and retry.
> /sys/svr/pgs/bin/postmaster: cannot create UNIX stream port

> There is no other postmaster running and there is no socket node file in
> /tmp

That's really weird.  Is it possible that there are still some old
clients holding open connections on that socket address, even though
you shut down the old postmaster?

For INET sockets, there's a timeout in many kernels, such that the
address that had been used for an INET socket is considered "in use"
for a few minutes after you close the socket.  I've never heard of
any similar behavior for Unix sockets, however.  Ideas anyone?

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* postmaster: address already in use
@ 2001-01-04 07:31  Markus Wagner <wagner@imsd.uni-mainz.de>
  0 siblings, 1 reply; 2+ messages in thread

From: Markus Wagner @ 2001-01-04 07:31 UTC (permalink / raw)
  To: pgsql-sql

Hi,

my postmaster suddenly begins to make problems. It was running fine, but
then:

FATAL: StreamServerPort: bind() failed: Address already in use
        Is another postmaster already running on that port?
        If not, remove socket node (/tmp/.s.PGSQL.5432) and retry.
/sys/svr/pgs/bin/postmaster: cannot create UNIX stream port

There is no other postmaster running and there is no socket node file in
/tmp

Any hints??
Thank you,

Markus



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-01-04 07:31 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-04 07:31 postmaster: address already in use Markus Wagner <wagner@imsd.uni-mainz.de>
2001-01-04 07:01 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox