[GENERAL] Initalizing PostgreSQL Database

[Richard Huxton]

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