Date: Mon, 15 Sep 2003 15:58:37 +0100 From: Richard Huxton <dev@archonet.com> To: KG <lists@i2iwebsolutions.com>, pgsql-general@postgresql.org, freebsd-questions@freebsd.org Subject: Re: [GENERAL] Initalizing PostgreSQL Database Message-ID: <200309151558.37383.dev@archonet.com> In-Reply-To: <1063635009.3f65c841c8333@www.i2iwebsolutions.com> References: <1063635009.3f65c841c8333@www.i2iwebsolutions.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200309151558.37383.dev>