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

Re: PGACCESS connection failure?

From: "William West" <wwest(at)csc(dot)com>
To: Preston Lord <webmaster(at)t2(dot)net>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: PGACCESS connection failure?
Date: 2002-07-29 22:38:32
Message-ID: OF9F8F598E.C22F3290-ON85256C05.007BAB94@com (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
Ran into similar symptoms, found that most utilities
(psql, for example) on the localhost use the Unix
Domain and work fine, but pgaccess uses TCP/IP.

My pg_hba.conf had a host statement to allow
TCP/IP, but postmaster did not have '-i' to enable
TCP/IP. I needed both to use pgaccess.

                    Preston Lord                                                                                                              
                    <webmaster           To:     pgsql-interfaces(at)postgresql(dot)org                                                              
          >             cc:                                                                                                  
                    Sent by:             Subject:     [INTERFACES] PGACCESS connection failure?                                               
                    01:05 PM                                                                                                                  

Hi List!

I love the look of the pgaccess gui BUT
upon trying to connect to my postgres server I get
the error:

Error trying to connect to database 'dbname' on host localhost

PostgreSQL error message. Connection to database failed.
could not connect to server: Connection refused
Is the server running on host localhost and accepting TCP/IP connections
on prt 5432?

I am also running unix odbc and DataManager for unixodbc without any
trouble. I run SuSE Linux 8 Pro ... any help is appreciated.



Preston Lord
Network Specialist
General Manager
Double T Computer Services
Sask, Canada

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


pgsql-interfaces by date

Next:From: Iavor RaytchevDate: 2002-07-29 22:50:12
Subject: Re: PGACCESS connection failure?
Previous:From: Cliff WellsDate: 2002-07-29 22:23:30
Subject: ECPG and dynamic SQL

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