LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 07-30-2017, 08:12 PM   #1
Doug Hutcheson
Member
 
Registered: Jun 2009
Location: Queensland
Distribution: Fedora 30; HP Pavilion 8Gb and Acer Aspire 16Gb; both Intel Core-i7
Posts: 290

Rep: Reputation: 22
Upgraded two laptops to Fedora 26 - now cannot connect to remote PostgreSQL


As the subject says, I have upgraded our home network from F25 to F26. I have managed to get local connections to PostgreSQL working, but neither machine can connect to the other's instance.

I can ssh between one machine and the other. I can rsync from one machine to the other. This makes me suspect it is not a network issue.

To test this, I did the following:

Code:
[root@womble data]# telnet ketchup
Trying 192.168.0.101...
telnet: connect to address 192.168.0.101: No route to host
[root@womble data]# route
Kernel IP routing table
Destination     Gateway         Genmask         Flags Metric Ref    Use Iface
default         gateway         0.0.0.0         UG    600    0        0 wlp3s0
192.168.0.0     0.0.0.0         255.255.255.0   U     600    0        0 wlp3s0
192.168.122.0   0.0.0.0         255.255.255.0   U     0      0        0 virbr0
I am reasonably competent with Linux, but not with networking, so I am not sure if the above is meaningful. The message "no route to host" has me baffled considering my success with ssh and rsync.

While you are scratching your head, can you guide me into setting up IPv6 on one machine so pgModeler can connect from the other? This is the first time I have had to look at IPv6 and I know less than nothing about it. I looked at some Google hits on IPv6 addressing and my brain exploded. "8-[

Anyone willing to talk me through fixing these issues will be awarded a virtual beer (or other beverage of choice).

Kind regards,
Doug
 
Old 07-30-2017, 08:29 PM   #2
Doug Hutcheson
Member
 
Registered: Jun 2009
Location: Queensland
Distribution: Fedora 30; HP Pavilion 8Gb and Acer Aspire 16Gb; both Intel Core-i7
Posts: 290

Original Poster
Rep: Reputation: 22
Doh! telnet doesn't work because I have it disabled in the firewalls. (Slaps forehead). Is it going to be something that simple which is blocking postgresql? I have postgresql enabled in both firewalls.

Hmmm ... I will keep digging.
 
Old 07-30-2017, 08:47 PM   #3
Doug Hutcheson
Member
 
Registered: Jun 2009
Location: Queensland
Distribution: Fedora 30; HP Pavilion 8Gb and Acer Aspire 16Gb; both Intel Core-i7
Posts: 290

Original Poster
Rep: Reputation: 22
Double Doh! postgresql.conf needed to be told to listen on all addresses '*'. I hope my conversation with myself has been entertaining if not instructive.

I will now have my beverage (virtually, of course).
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Unable to connect to remote PostgreSQL database with java.derby ChrisKlinger Linux - Server 1 08-28-2010 03:06 AM
How to connect two laptops with the help of a cross cable in fedora 9? Bringo Linux - Networking 4 05-03-2010 03:36 PM
Allowing remote connect to Postgresql shubb Linux - Server 6 04-12-2007 02:07 AM
Connect 2 Laptops Via Ethernet? Swampy Linux - Laptop and Netbook 2 06-09-2004 04:33 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 05:27 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration