| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | KG <lists(at)i2iwebsolutions(dot)com>, pgsql-general(at)postgresql(dot)org, freebsd-questions(at)freebsd(dot)org |
| Subject: | Re: Initalizing PostgreSQL Database |
| Date: | 2003-09-15 14:58:37 |
| Message-ID: | 200309151558.37383.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-09-15 15:14:56 | Re: Initalizing PostgreSQL Database |
| Previous Message | Tom Lane | 2003-09-15 14:54:22 | Re: Table spaces (was Re: State of Beta 2) |