Re: problem getting started with PostgreSQL 8 beta 3 on

From: Steve Gollery <sgollery(at)cadrc(dot)calpoly(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: problem getting started with PostgreSQL 8 beta 3 on
Date: 2004-10-01 21:51:36
Message-ID: 415DD168.8030902@cadrc.calpoly.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers-win32

Tom,

False alarm -- I just realized that I was picking up the createdb from
an earlier failed attempt to install 7.4.5. Removing that got me to the
right command and all is well.

Thanks for the help.

Steve

Tom Lane wrote:
> 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

Browse pgsql-general by date

  From Date Subject
Next Message Astha Raj 2004-10-01 23:24:41 ODBC for PostgreSQL 7.4
Previous Message Tom Lane 2004-10-01 21:40:09 Re: problem getting started with PostgreSQL 8 beta 3 on XP

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Harald Armin Massa 2004-10-03 08:55:29 pg_restore / psql -f massive problems with copy from ...
Previous Message Tom Lane 2004-10-01 21:40:09 Re: problem getting started with PostgreSQL 8 beta 3 on XP