pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: 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