Re: Initalizing PostgreSQL Database

Quoting Richard Huxton <dev@archonet.com>:

> 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


Thanks I figured it out. I went to the /usr/local/pgsql directory and ran
initdb. All is well now.

Kevin
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>