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

Re: Unable to connect to a server

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Unable to connect to a server
Date: 2008-11-12 10:51:02
Message-ID: 20081112105102.GE13765@a-kretschmer.de (view raw or flat)
Thread:
Lists: pgsql-novice
am  Tue, dem 11.11.2008, um 17:37:35 -0800 mailte Steve Henry folgendes:
> I'm a newbie, using the Mac platform.
> 
> I've installed PostgreSQL on a server and can run PostgreSQL based  
> application from that server with no problem.  But when I try to  
> access the DB on a different computer, pointing to the server for the  
> log in, I get this error:
> 
> A connection to the specified xTuple ERP Server cannot be made. This  
> may be due to an incorrect Username and/or Password or the server in  
> question cannot support any more connections.
> Please verify your Username and Password and try again or wait until  
> the specified xTuple ERP Server is less busy.
> System Error
> QPSQL: Unable to connect
> 
> From doing some reading, I think the solution is to change the value  
> of  listen_addresses to '*'

Not only that, you should also edit your pg_hba.conf to allow remote
access.


> 
> But I don't know where to do that.  I'm using pgAdmin3.  Can it be  
> done there?  Or do I need to use Terminal?

I'm not familiar with PGAdmin...


HTH, Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

In response to

Responses

pgsql-novice by date

Next:From: Bob McConnellDate: 2008-11-12 12:07:24
Subject: Re: Unable to connect to a server
Previous:From: Obe, ReginaDate: 2008-11-12 05:53:37
Subject: Re: Automating Postgres Backup

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