Skip site navigation (1) Skip section navigation (2)

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steve Gollery <sgollery(at)cadrc(dot)calpoly(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: problem getting started with PostgreSQL 8 beta 3 on XP
Date: 2004-10-01 21:40:09
Message-ID: 15224.1096666809@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers-win32
Steve Gollery <sgollery(at)cadrc(dot)calpoly(dot)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

In response to

Responses

pgsql-hackers-win32 by date

Next:From: Steve GolleryDate: 2004-10-01 21:51:36
Subject: Re: problem getting started with PostgreSQL 8 beta 3 on
Previous:From: Oliver D.Date: 2004-10-01 21:16:24
Subject: Win32 libpq : Static Link ?

pgsql-general by date

Next:From: Steve GolleryDate: 2004-10-01 21:51:36
Subject: Re: problem getting started with PostgreSQL 8 beta 3 on
Previous:From: Tom LaneDate: 2004-10-01 21:19:29
Subject: Re: Upgrade 7.3.3 to 7.4.5

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group