age icon indicating copy to clipboard operation
age copied to clipboard
verified publisher icon apache

Unable to connect Apache Age-Viewer to PostgreSQL Database

Open moiz697 opened this issue 3 years ago • 7 comments

I have tried all the steps provided in the documentation to connect Apache Age-Viewer to my PostgreSQL database, but I am still unable to connect. I have verified that the PostgreSQL server is running, the user and password are correct and have the necessary permissions, and the specified port (5455) is open and accessible. But I still can't connect.

I am using the following versions:

Apache Age-Viewer: 14.16.0 PostgreSQL: 12.13

moiz697 avatar Jan 19 '23 23:01 moiz697

@moiz697 @eyab This issue belongs under https://github.com/apache/age-viewer/issues

jrgemignani avatar Jan 20 '23 00:01 jrgemignani

Please close this issue once it is added under the viewer.

jrgemignani avatar Jan 26 '23 16:01 jrgemignani

It is possible that there are some issues related to the versions. I suggest you change your Postgres and AGE versions. Here is the link for a step-by-step guide on how to do it and which versions are the best.

https://theundersurfers.netlify.app/age-installation/

Try to use the steps in this article. The video is also attached for guidance.

moaz178 avatar Apr 28 '23 17:04 moaz178

Please try updating both your PostgreSQL and Apache AGE, as there may be issues with older versions.

M4rcxs avatar May 09 '23 22:05 M4rcxs

Try first to run postgres and age in the terminal and make sure that they are working good. Also make sure that you are using the correct user name and password while connecting to the database. Another thing the default postgres port is 5432 not 5455 unless you changed it. If you are still facing an issue, you can follow this tutorial to install and run Apache Age-Viewer: https://dev.to/omarsaad/step-by-step-guide-to-install-apache-age-viewer-1o5d

Omar-Saad avatar May 09 '23 22:05 Omar-Saad

Check if there are any firewalls or network restrictions that may be blocking the connection. You can try temporarily disabling the firewall or any other network security software and attempt to connect again. And also try to check the PostgreSQL server logs for any error messages related to the connection attempt. The logs may provide more information on why the connection is failing.

dukeofhazardz avatar May 09 '23 22:05 dukeofhazardz

I faced a similar problem, so I referred to these two links:

  1. https://age.apache.org/age-manual/master/intro/setup.html#pre-installation
  2. https://theundersurfers.netlify.app/age-installation/

mahinash26 avatar May 17 '23 18:05 mahinash26