Re: [GENERAL] postgresql jdbc connect via hostname instead of just ip
Thanks for the help - it was a dns resolving issue after all as you described. Jonathan --- Douglas McNaught <[EMAIL PROTECTED]> wrote: > Jonathan Schreiter <[EMAIL PROTECTED]> > writes: > > > The only way I can connect to the database via > JDBC > > seems to be by IP address (both locally and on > another > > system allowed by the pg_hba.conf file). > > > > > jdbc:postgresql://theipaddressofdatabaseserver/mydatabase > > > > I'd like to be able to connect to the database > this > > way using a DNS name / computer host name. The > > specific error I recieve is on the lines of no > route > > to host. > > This implies that the IP address in DNS or > /etc/hosts is different > from the IP address you're using in the URL. It's > almost certainly > not a Postgres misconfiguration. What happens when > you do > > telnet server.host.name 5432 > > on the JDBC client machine? > > -Doug > ---(end of broadcast)--- TIP 6: explain analyze is your friend
[GENERAL] postgresql jdbc connect via hostname instead of just ip
Hi all, I'm a bit new to postgresql. I've been able to configure the database and the jdbc interface successfully. I interface via PAM (krb5) and that works OK in the pg_hba.conf file. I've added the -i option to the postmaster startup script service (using binary RPMs on Fedora Core 4) for tcp connections (default port 5432). The only way I can connect to the database via JDBC seems to be by IP address (both locally and on another system allowed by the pg_hba.conf file). jdbc:postgresql://theipaddressofdatabaseserver/mydatabase I'd like to be able to connect to the database this way using a DNS name / computer host name. The specific error I recieve is on the lines of no route to host. I'm sure I'm just missing a simple setting somewhere. Can anyone point me in the right direction? pg_hba.conf host mydatabase all 127.0.0.1/32 pam host mydatabase all theipsubnet/24 pam Many thanks, Jonathan ---(end of broadcast)--- TIP 6: explain analyze is your friend
[GENERAL] pgadmin3 / postgresql newbie question
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 [EMAIL PROTECTED])
