From owner-freebsd-questions Fri May 12 6:30:57 2000 Delivered-To: freebsd-questions@freebsd.org Received: from gold.killercomputing.com (ATHM-216-216-77-156.home.net [216.216.77.156]) by hub.freebsd.org (Postfix) with ESMTP id DD53837BB3D for ; Fri, 12 May 2000 06:30:53 -0700 (PDT) (envelope-from pulcher@killercomputing.com) Received: from popgun ([199.233.181.2]) by gold.killercomputing.com (8.9.3/8.9.3) with SMTP id IAA45082; Fri, 12 May 2000 08:31:56 -0500 (CDT) (envelope-from pulcher@killercomputing.com) Message-ID: <01dd01bfbc17$e0fb52a0$02b5e9c7@killercomputing.com> From: "Harold Pulcher - Killer Computing" To: "Bart Lateur" , References: <3924ebda.9815427@relay.skynet.be> Subject: Re: PostgreSQL boot question Date: Fri, 12 May 2000 08:42:12 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG > After that, postgreSQL refused to run because the socket > (/tmp/s.postgres.5432 or some name like that) was "in use". I had to > delete the file and reboot to make it work. I could get rid of the file > without problem by simply rm-ing it. You really didn't need to reboot. After you rm'ed the file, just run the startup script pgsql.sh. It will fire right up. > > This doesn't look right: it's too much manual work. > > Does this mean I'll have to do that every time my server crashes? Can't > the file automatically be deleted at startup, before the postgreSQL > demon starts up? > It is a little risky, but I just modified the above script to check for the existence of the file and rm the thing if it exists. Since the script is really only intended to be executed at boot time, and you need to have rootly type privs to remove the file, I don't see it as that big of a deal. Especially, when you catch the "crashitus" that sometimes goes around. Harold To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message