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 _______________________________________________ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"