Re: pgadmin3 / postgresql newbie question

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(at)yahoo(dot)com> wrote in message
news:20050302111535(dot)65731(dot)qmail(at)web20121(dot)mail(dot)yahoo(dot)com(dot)(dot)(dot)
> 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(at)postgresql(dot)org)
>