That particular error message is typically associated with a missing pg_hba.conf entry that tells the postgreSQL server which remote machines to allow connections FROM.... # If you want to allow non-local connections, you need to add more # "host" records. Also, remember TCP/IP connections are only enabled # if you enable "tcpip_socket" in postgresql.conf. # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD local all all trust # IPv4-style local connections: host all all 127.0.0.1 255.255.255.255 trust # IPv6-style local connections: host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust host all all 10.1.10.23 255.255.255.255 trust Regards.... "Jonathan Schreiter" <jonathanschreiter@xxxxxxxxx> wrote in message news:20050302111535.65731.qmail@xxxxxxxxxxxxxxxxxxxxxxxxxx > hi all, > running amd64 fedora core 3 w/ default postgresql > 7.4.7-3. did asu - , su postgres and createdb mydb as > explained in the postgresql tutorial. installed the > latest pgadmin3 and am trying to connect to this > database. as i wasn't sure what the FC3 default > password was for postgres, i changed it to something i > could remember. > > i can't seem to connect to the new database using > pgadmin3. i have the correct IP address of the local > computer, default port 5432, mydb as the initaldb, > postgres as the username, and my new password as the > password. i keep getting the error > > Error connecting to the server: could not connect to > server: Connection refused > Is the server running on host "192.168.1.24" and > accepting > TCP/IP connections on port 5432? > > i also verified the postgresql service is running, and > that i've added the following to > /etc/raddb/postgresql.conf: > login = "postgres" > password = "mynewpassword" > > and right underneath it: > tcpip = true > > i've also disabled my local firewall and SELINUX just > for kicks. and yes, i did a reboot. > > so...anyone know what else i can look at? > > many thanks! > jonathan > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx) > ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
