#JDBC Postgres doesn't connect

1 messages · Page 1 of 1 (latest)

warm seal
#

I tried to connect to my other laptop's database but i keep getting this error
org.postgresql.util.PSQLException: The connection attempt failed
I can connect to my own database just fine

gaunt ermineBOT
#

<@&987246399047479336> please have a look, thanks.

gaunt ermineBOT
#

While you are waiting for getting help, here are some tips to improve your experience:

Code is much easier to read if posted with syntax highlighting and proper formatting.

If nobody is calling back, that usually means that your question was not well asked and hence nobody feels confident enough answering. Try to use your time to elaborate, provide details, context, more code, examples and maybe some screenshots. With enough info, someone knows the answer for sure.

Don't forget to close your thread using the command </help-thread close:1027500463647621170> when your question has been answered, thanks.

#

Here is an AI assisted attempt to answer your question 🤖. Maybe it helps! In any case, a human is on the way 👍. To continue talking to the AI, you can use </chatgpt:1108714622413963314>.

#

tabase on my laptop, but not to the other laptop's database. What could be the issue?

There could be several reasons for this issue. Here are a few things you can check:

  1. Network connectivity: Ensure that both laptops are connected to the same network and can communicate with each other. You can try pinging the other laptop from your laptop to verify network connectivity.

  2. Firewall settings: Check if there are any firewall rules blocking the connection between the two laptops. Make sure that the necessary ports (default is 5432 for PostgreSQL) are open and accessible.

  3. PostgreSQL configuration: Verify that PostgreSQL is configured to allow remote connections. By default, PostgreSQL only listens on localhost (127.0.0.1). You may need to modify the postgresql.conf file and set listen_addresses to '*' or specify the IP address of your other laptop.

  4. User authentication: Ensure that you have provided correct credentials (username and password) to connect to the other laptop's database.

  5. Database permissions: Check if the user you are using to connect has sufficient privileges to access and connect to the database on the other laptop.

  6. JDBC driver version: Make sure that you have compatible versions of JDBC driver for PostgreSQL installed on both laptops.

If none of these suggestions resolve your issue, it would be helpful to provide more details about your setup, such as operating systems, PostgreSQL versions, and any relevant error logs or stack traces for further assistance.

wheat imp
#

Can you ssh into the other laptop? Have you confirmed the database server is running and you can access that database on the laptop itself? Are you using a custom port? Login credentials are valid (ie, they work on the laptop itself)?