Re: PGACCESS connection failure?

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@postgresql.org
                                                                               @t2.net>             cc:
                                                                                                   Sent by:
Subject:    [INTERFACES] PGACCESS connection failure?
pgsql-interfa
                   ces-owner


                                                                               07/29/2002
                                                                                                   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.




--

Regards

Preston Lord
Programmer/Developer
Network Specialist
_______________
General Manager
Double T Computer Services
Sask, Canada
1.306.773.2054
http://www.t2.net


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

http://archives.postgresql.org