Date: Sat, 9 Sep 2000 19:36:17 +0200 From: Francesco Casadei <fcasadei@inwind.it> To: Ilia Chipitsine <ilia@cgu.chel.su> Cc: questions@FreeBSD.ORG Subject: Re: postgres7 @ FreeBSD-4.1S Message-ID: <20000909193617.A295@goku.kasby> In-Reply-To: <Pine.BSF.4.10.10009091257001.615-100000@jane.cgu.chel.su>; from ilia@cgu.chel.su on Sat, Sep 09, 2000 at 12:58:52PM %2B0600 References: <Pine.BSF.4.10.10009091257001.615-100000@jane.cgu.chel.su>
next in thread | previous in thread | raw e-mail | index | archive | help
On Sat, Sep 09, 2000 at 12:58:52PM +0600, Ilia Chipitsine wrote:
> every time it boots there's the following message
> ----------------------------------------------------------------------
> pg_ctl: It seems another postmaster is running. Try to start postmaster
> anyway.
> pg_ctl: Cannot start postmaster. Is another postmaster is running?
> 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.
> /usr/local/pgsql/bin/postmaster: cannot create UNIX stream port
> ----------------------------------------------------------------------
>
> the only way to start postgres7 is to remove that file ?
> anyone else seen that ?
>
> Regards, (Nailucsie pozelanij)
> Ilia Chipitsine (Il%j Sipicin)
>
>
>
> To Unsubscribe: send mail to majordomo@FreeBSD.org
> with "unsubscribe freebsd-questions" in the body of the message
>
> end of the original message
It happens when postgres is not shutted down cleanly. If you
installed it from ports then use:
/usr/local/etc/rc.d/pgsql.sh stop
to shut it down (the system does this automatically when you shut it
down or restart it) and then:
/usr/local/etc/rc.d/pgsql.sh start
to restart it.
Personally, I've seen that when I had a power outage at home. No
problems, however, I removed /tmp/.s.PGSQL.5432 as stated in the
error message and restarted postgres.
Francesco Casadei
To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20000909193617.A295>