I installed Postgres 8 beta 3 on an XP box, with Postgres running as a service. TaskManager tells me that postgres and postmaster are both running. Using pgAdmin III, I can connect to the server and create users, databases, tables, etc.

But at the command line, on the same machine where the service is running, executing

createdb mydb

gives this:

could not connect to database template1: 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"?

The documentation says:

"This means that the server was not started, or it was not started where createdb expected it."

Since pgAdmin has no trouble connecting, I assume that the server is running and receiving connections at port 5432, so that leaves the second part: not started where createdb expected it.

I've tried explicitly including the host, port, user, password, and that doesn't help.

Any ideas what's going wrong here?

Steven Gollery
[EMAIL PROTECTED]

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to