Re: problem getting started with PostgreSQL 8 beta 3 on XP

Steve Gollery <sgollery@cadrc.calpoly.edu> writes:
> 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"?

Steve: try
    createdb -h localhost mydb

Pghackers: I'm surprised that we don't have libpq set to default to
"localhost" rather than a Unix socket on platforms that haven't got Unix
sockets.  A default that's guaranteed not to work seems a bit useless.

Anyone have a better idea than "localhost"?

            regards, tom lane