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

Re: postgresql problem

From: Jason Tishler <Jason(dot)Tishler(at)dothill(dot)com>
To: Jane G <jane(dot)gu(at)jungledrum(dot)co(dot)nz>
Cc: pgsql-ports(at)postgresql(dot)org
Subject: Re: postgresql problem
Date: 2001-03-06 00:34:41
Message-ID: 20010305193441.X1165@dothill.com (view raw or flat)
Thread:
Lists: pgsql-ports
Jane,

On Tue, Mar 06, 2001 at 01:19:38PM +1300, Jane G wrote:
> Sorry i have to bother you again.  I followed your advise to use Cygwin
> 1.1.8-2  with cygwin1.dll(written in 20010216) from the snapshot list. Then
> i can start my postmaster.  But when i tried to run 'psql -h localhost
> template1',  it stucked.  The error message is:
> "psql: connectDBStart() -- connect() failed: No such file
>     Is the postmaster running at 'localhost'
>     and accepting connections on Unix socket '5432'?"
> I checked my socket number and it was 5432.
> Could you give me another advise?

Kevin's howto is a "little" dated.  You no longer need to use TCP/IP
sockets to connect to postmaster under Cygwin, you can now use the
default Unix domain sockets (as on other Unix platforms).  Hence,
the solution to the problem above is to start psql *without* the "-h
localhost" option.  Otherwise, you need to start postmaster with the
"-i" option which instructs it to listen on TCP/IP sockets too.

Jason

-- 
Jason Tishler
Director, Software Engineering       Phone: +1 (732) 264-8770 x235
Dot Hill Systems Corp.               Fax:   +1 (732) 264-8798
82 Bethany Road, Suite 7             Email: Jason(dot)Tishler(at)dothill(dot)com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com

In response to

Responses

pgsql-ports by date

Next:From: Jason TishlerDate: 2001-03-06 02:17:18
Subject: Re: help on pgsq windows 2000 port
Previous:From: Jason TishlerDate: 2001-03-05 22:34:07
Subject: Re: How Do I install Postgresql on Windows 2000

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