Make sure you have started the server allowing TCP/IP connections (-i option form postmaster command). Otherwise, only local Unix domain socket connections are accepted.
Regards, Raul Gutierrez "Andrei Verovski (aka MacGuru)" wrote: > > Hi, > > I have problem with SuSE Linux 8.1 and PostgreSQL 7.3 (all SuSE built > packages). > > PostgreSQL server (which is launched via "rcpostgesql start") refuses > connections from localhost (to any database), whenever I am trying to > connect with phpPgAdmin or pgaccess with message "blah blah blah... > refused connection" as user "postgres" and no password (or password of > UNIX user "postgres"). > > However, I can connect with psql command-line utility as user > "postgres", AND with Webmin (without any additional logon parameters > except root/password at the beginning). This is quite strange. > > I have checked PostgreSQL config files (hba.conf), and enabled all > connections from localhost and local network (192.168.*.*) with "trust" > parameter. > > Also, I have changed password for UNIX user "postgres" as "abc", but > anyway, it did not worked from PHP and pgaccess. > > PS. Yes, I have done "initdb", and PostgreSQL server is running. > > Thanks in advance for any suggestion. > > ********************************************* > * Best Regards --- Andrei Verovski > * > * Personal Home Page > * http://snow.prohosting.com/guru4mac > * Mac, Linux, DTP, Development, IT WEB Site > ********************************************* > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
