From owner-freebsd-questions Sat Sep 9 10:47:23 2000 Delivered-To: freebsd-questions@freebsd.org Received: from relay1.inwind.it (relay1.inwind.it [212.141.53.67]) by hub.freebsd.org (Postfix) with ESMTP id C031C37B422 for ; Sat, 9 Sep 2000 10:47:21 -0700 (PDT) Received: from [212.141.250.45] (212.141.250.45) by relay1.inwind.it (5.1.046) id 39AFDC9900112856 for questions@FreeBSD.ORG; Sat, 9 Sep 2000 19:47:15 +0200 Received: (qmail 929 invoked by uid 1000); 9 Sep 2000 17:36:17 -0000 Date: Sat, 9 Sep 2000 19:36:17 +0200 From: Francesco Casadei To: Ilia Chipitsine Cc: questions@FreeBSD.ORG Subject: Re: postgres7 @ FreeBSD-4.1S Message-ID: <20000909193617.A295@goku.kasby> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: ; from ilia@cgu.chel.su on Sat, Sep 09, 2000 at 12:58:52PM +0600 X-Operating-System: FreeBSD 4.1-STABLE i386 Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG 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