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

Re: pgaccess - client wont access testdb

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: streethockey(at)ureach(dot)com
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: pgaccess - client wont access testdb
Date: 2002-01-28 14:55:52
Message-ID: 1012229752.21964.80.camel@linda (view raw or flat)
Thread:
Lists: pgsql-interfaces
On Mon, 2002-01-28 at 14:07, Eric Webber wrote:

> pgaccess X client comes up fine but when I try to open a database
> I get the error:
> 
> "Error trying to connect to database 'testdb' on host localhost
> 
> PostgreSQL error message: Connection to database failed
> 
> connectDBStart() - connect() failed: Connection refused
> IS the postmaster running (with -i) at 'localhost'
> and accepting connections on TCP/IP port 5432?"
> 
> 
> Why would I get this when psql works fine ?
> 
> What am I doing wrong ?  How would I check what port it is running 
> on and whether is running with -i and at localhost ?
> 
> Isnt the fact psql works proof enough that pgacess should work
> too in terms of connectivity ?


Your problem is that you have retained pgaccess' default host
(localhost) in the connection dialog.  If you have anything at all in
the host field when you connect, pgaccess tries to use a TCP/IP
connection, which you have not enabled.

Blank out the host field and pgaccess will use Unix sockets.

-- 
Oliver Elphick                                Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "Many are the afflictions of the righteous; but the 
      LORD delivereth him out of them all."             
                                        Psalm 34:19 

In response to

pgsql-interfaces by date

Next:From: Jean-Luc LachanceDate: 2002-01-28 18:54:50
Subject: Re: PGACCESS installation
Previous:From: Eric WebberDate: 2002-01-28 14:07:54
Subject: pgaccess - client wont access testdb

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