From owner-freebsd-questions@FreeBSD.ORG Mon Sep 15 07:58:43 2003 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id AEFB516A4C2 for ; Mon, 15 Sep 2003 07:58:43 -0700 (PDT) Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net [194.217.242.89]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8B76243F85 for ; Mon, 15 Sep 2003 07:58:41 -0700 (PDT) (envelope-from dev@archonet.com) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-31.mail.demon.net with esmtp (Exim 3.35 #1) id 19yuoK-0007jL-0V; Mon, 15 Sep 2003 15:58:40 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id B622316BF8; Mon, 15 Sep 2003 15:58:38 +0100 (BST) Received: from client17.archonet.com (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 0E4AC16BDE; Mon, 15 Sep 2003 15:58:38 +0100 (BST) From: Richard Huxton To: KG , pgsql-general@postgresql.org, freebsd-questions@freebsd.org Date: Mon, 15 Sep 2003 15:58:37 +0100 User-Agent: KMail/1.5 References: <1063635009.3f65c841c8333@www.i2iwebsolutions.com> In-Reply-To: <1063635009.3f65c841c8333@www.i2iwebsolutions.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200309151558.37383.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 Subject: Re: [GENERAL] Initalizing PostgreSQL Database X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 15 Sep 2003 14:58:43 -0000 On Monday 15 September 2003 15:10, KG wrote: > I'm getting the following error message when I try to create a user or > database on postgresql 7.2.2 on Freebsd 4.7, I installed it from the ports > directory but I'm stumped when I got the following error message. When I do I don't know anything about the BSDs but 7.2.4 was the last of the 7.2 series - upgrade if at all possible. > $ createdb test1 > psql: could not connect to server: No such file or directory > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PGSQL.5432"? > createdb: database creation failed Does a "ps" show anything running (postmaster)? I'm guessing not, since it can't find the socket. Have you run "initdb"? You need to do this to initialise the system, create required files etc. I don't know if your startup script does this for you. Is the "postgres" or "pgsql" (or whatever) user setup, does it have permission to access your target data/base directory? -- Richard Huxton Archonet Ltd