[GRASSLIST:1154] Re: trouble with g.select.pg

[Eric G . Miller]

On Mon, Nov 20, 2000 at 11:51:27AM +0100, mlennert at club.worldonline.be wrote:
> I've already sent this message to the sqlgrass-list, but this list doesn't 
> seem very active. Shouldn't we maybe merge it with the main grass list again ?
> ----------------------------------- 
> 
> When trying to run g.select.pg I get the classic error message :
> Error: select Postgres:PQconnectPoll() -- connect() failed: Connection refused
>         Is the postmaster running (with -i) at 'localhost'
>         and accepting connections on TCP/IP port '5432'?
> 
> However, postmaster is running on 5432. I can see the databases with 
> 'g.select.pg -l' and I can connect to them with pg_access. The only thing that 
> seems a bit bizarre is that I cannot enter a host name when connecting through 
> pg_access. If I do I get the same message as above. But when I don't I can 
> connect without any trouble. I remember getting this hint from the pg_access 
> web page or mailing list, so it seems to be a known phenomenon. Could this be 
> the same problem with g.select.pg ?

Yes, I brought this up before.  Seems the code hasn't been changed (I
didn't want to change others code).  The problem is the the interface
with username/password pairs.  The code should be sending user=NULL,
password=NULL, hostname=NULL, but instead sends hostname="localhost",
which causes a TCP/IP connection vs. a UNIX socket, which will probably
make your configuration demand a valid username/password pair.  It's
definitely a bug, IMHO.


-- 
Eric G. Miller <egm2 at jps.net>