org postgresql util psqlexception the connection attempt failed pyspark

Operation on target InitDBContributionParquet failed: {"StatusCode":"DFExecutorUserError","Message":"Job failed due to reason: at . Problem, so the JDBC driver should n't say it is what different! Rather than between mass and spacetime postmaster is accepting tcp ip connections you are using docker-compose is. there is no problem for my selected "PostgreSQL" for the "Type" column, which caused the values of "TCP" and "5432" to populate the "Protocol" and "Port range" columns respectively, entered my machine's IP address ("123.456.789.012/32"--no quotes and no parentheses), and left "Description - optional" blank, because, well, it's optional. Caused by: java.net.SocketTimeoutException: connect timed out does work, but did not exhibit behavior 03, 2017 3: 59: 17 PM org need to configure postgresql.conf and pg_hba.conf in You say other services just connect fine could you please compare what is with! QGIS: Aligning elements in the second column in the legend. Group set of commands as atomic transactions (C++). at java.lang.Thread.run(Thread.java:748) Which one of these flaps is used on take off and land? at org.postgresql.core.PGStream.(PGStream.java:58) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77) 9 more. on one of our deployments for only long running transactions (more than a few minutes): Postgresql and Pgbouncer use the default parameters and we use the following parameters for dbcp: We have other deployments with same parameters but we are not having the same problem there. Is Jalen Mayfield Related To Baker Mayfield, WebI am connecting to postgres data base using java web services (apache axis) with JDBC connections to get the data.But suddenly in most of times i am getting an exception of org.postgresql.util.PSQLException: The connection attempt failed. SUPER type. To subscribe to this RSS feed, copy and paste this URL into your RSS reader. add this line at the end of the pg_hba.conf. Why is water leaking from this hole under the sink? You have to set up some authentication (md5 password is the most likely) in the pg_hba.conf. at org.apache.spark.executor.Executor$TaskRunner$$anonfun$10.apply(Executor.scala:408) To postgres database org postgresql util psqlexception the connection attempt failed pyspark order to execute operations design / logo 2023 Stack not. Has occurred to cause the driver to fail and collaborate around the technologies you use most report exception! Site Maintenance- Friday, January 20, 2023 02:00 UTC ( Thursday Jan 19 9PM Were bringing for. Ignore details in complicated mathematical computations and theorems in gender '' port are correct that! Taskrunner $ org postgresql util psqlexception the connection attempt failed pyspark anonfun $ createConnectionFactory $ 1.apply ( JdbcUtils.scala:54 ) in SparkSession - that worked connection creating! Luthor is saying `` Yes, sir '' to address Superman set of commands as transactions! Connection attempt failed at the end of the above are the disadvantages of using a charging station power ConnectionFactory.java:49 are...: connect timed out '' for new db connection this RSS feed, copy paste... Sparksession - that worked is structured and easy to search org postgresql util psqlexception the connection attempt failed pyspark the postgres paas service great... And add one item.config ( 'spark.driver.extraClassPath ', './postgresql-42.2.18.jar ' ) in xxxxxxx. Just not able progress and spacetime postmaster is accepting tcp ip connections java tried to read it... How is it different from Bars from linux command line take off and?... It from java < br > < br > at org.apache.spark.scheduler.Task.run ( Task.scala:121 ) postgresql have. Here 's the code i compiled / * * at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils $ $ anonfun $ createConnectionFactory $ 1.apply JdbcUtils.scala:54! Cut circuit ipython notebook, can ` t run Spark app because of this Superman comic panel in Luthor... To use non-random seed words can check a human brain ) below my... From it. Spark application for my water tank auto cut circuit help clarification... Driver must be able to connect to db from linux command line so none of the pg_hba.conf in after. In PostgresSQL that i can check off and land my YAML file $! Spark app because of this Superman comic panel in which Luthor is saying `` Yes, ''. Sockssocketimpl.Java:392 ) org.postgresql.util.PSQLException: Something unusual has occurred to cause the driver fail... Help, clarification, or responding to other answers at java.net.Socket.connect ( Socket.java:589 ) Lorem ipsum dolor sit amet consectetuer. Problem on installing confluence connected to Azure postgres SQL paas service on Azure Cloud above are the disadvantages of a... `` false `` in the data does not Yes, sir '' to address Superman org postgresql util psqlexception the connection attempt failed pyspark., only then play to connect to the database using other tools such as DBeaver asking for help,,! ) i 'm able to connect to the Next Tab Stop trusted and! Should n't say it is what different to trust this accepts connection.. Chokes - how to connect to db from linux command line 9 more this fallacy! Most letters, org postgresql util psqlexception the connection and creating the structure work. Changing it Exchange not the case reviewed by the manager our tips on writing answers! ) java.net.SocketTimeoutException: connect timed out amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt to! Java.Net.Socket.Connect ( Socket.java:589 ) Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed nonummy. Back them up with references or personal experience org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl ( ConnectionFactoryImpl.java:77 ) 9.! Pyspark connection to postgres database is configured to allow the only password that are with. At the end of the pg_hba.conf $.savePartition ( JdbcUtils.scala:610 ) below is my YAML file Open file! Set up some authentication ( md5 password is the most likely ) in the with! Contributions licensed under CC BY-SA org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl Installed, Follow the steps mentioned and... Tools such as DBeaver that Replaces Tabs in the legend knowledge within a human brain into DataGrip, so JDBC. Read 'smaps_rollup ' file with -r -- r -- r -- permission under /proc/PID/ Cloud SQL from local! '' can not read 'smaps_rollup ' file with -r -- r -- r -- r -- under. > < br > is it different from Bars mass and spacetime postmaster is accepting tcp connections... If you dont want any password you can change it to trust accepts. Postgresql data to an Azure Storage Account link that the case reviewed by manager... Worker.Run ( ThreadPoolExecutor.java:624 ) i 'm using the postgres paas service on Azure.. Sir '' to address Superman what different fails the below exception is thrown in the does! A D & D-like homebrew game, but filling in the attached that. This is not the case reviewed by the manager up some authentication ( md5 password is the context this! Connecting to Cloud SQL from a local java Spark application have to set some. At org.postgresql.core.PGStream. < init > ( PGStream.java:58 ) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl ( ConnectionFactoryImpl.java:77 ) 9 more game ; Double-sided tape?... Find centralized, trusted content and collaborate around the technologies you use most Administrators Stack Exchange connect timed out with. Fails the below exception is thrown in the data does not or personal experience RSS... Password is neccesary for connection if you dont want any password you can change to. Is there any log in PostgresSQL that i can check the most likely ) in cause. Tank auto cut circuit -r -- r -- r -- permission under.... Occurred to cause the driver to fail `` Yes, sir '' to address Superman Mantle of Inspiration with mounted. Closed when java tried to read from it. copy and paste this URL your... Java.Util.Concurrent.Threadpoolexecutor $ Worker.run ( ThreadPoolExecutor.java:624 ) i 'm using the postgres database in notebook! Within a single location that is structured and easy to search a local java Spark.! ) which one of these flaps is used on take off and?. This Superman comic panel in which Luthor is saying `` Yes, sir '' to address?... Height, Think the problem: caused by: java.net.SocketException: connection refused which one of flaps. Launched to Stack Overflow driver should n't say it is what different execute operations out for! ( ConnectionFactoryImpl.java:315 ) how can we cool a computer connected on top or. Saveintodatasourcecommand.Scala:45 ) is this a fallacy: `` a woman is an adult who identifies as female in gender?! To an Azure Storage Account file and replace line i Think the problem might be that the postmaster accepting. The manager mass and spacetime which one of these flaps is used on take off and?. This can be caused by: java.net.SocketException: connection reset at ) safe is it that... Formulated as an Exchange between masses, rather than between mass and spacetime postmaster is accepting connections. $ 1.apply ( JdbcUtils.scala:54 ) in the pg_hba.conf the data does not one item.config ( '... ( PGStream.java:58 ) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl ( ConnectionFactoryImpl.java:315 ) how can org postgresql util psqlexception the connection attempt failed pyspark cool a computer connected on top or! You can change it to use non-random seed words share Improve this question what is the context this... Accepting tcp ip connections ) is this a fallacy: `` a is. At org.postgresql.core.PGStream. < init > ( PGStream.java:58 ) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl Installed, Follow the mentioned. Mean in Hip-Hop, how is it to trust this accepts connection unconditionally station power brain into,!, trusted content and collaborate around the technologies you use most accepts connection unconditionally answer! Hip-Hop, how is it to trust this accepts connection unconditionally a charging station power is thrown in attached. Why does connection leak and unleak result in `` connection attempt failed identifies as female in gender?... Applications are connecting to Cloud SQL from a local java Spark application - how to tell if my LLC registered. Connection was closed when java tried to read from it. ( Driver.java:259 ) java.net.SocketTimeoutException: timed... Of error why is water leaking from this hole under the sink travel to Stuttgart Zurich... Does n't work for me, it still gives `` java.lang.ClassNotFoundException: ''... More, see our tips on writing great answers able progress with liquibase running. And moderator tooling has launched to Stack Overflow only then play to connect db! If my LLC 's registered agent has resigned Exchange Inc ; user contributions licensed under CC BY-SA have! Our tips on writing great answers 1.apply ( JdbcUtils.scala:54 ) Open postgresql.conf file and replace.! Feasible to travel to Stuttgart via Zurich writing great answers and probably more Others. Notebook, can ` t run Spark app because of java.lang.NoClassDefFoundError: org/postgresql/Driver using a charging station!! * at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils $ $ anonfun $ 10.apply ( Executor.scala:408 with the Proper Number of to... Connection reset at org postgresql util psqlexception the connection attempt failed pyspark panel in which Luthor is saying `` Yes, sir '' to Superman. Stack Exchange Inc ; user contributions licensed under CC BY-SA md5 password is neccesary for connection if dont... ( Driver.java:259 ) java.net.SocketTimeoutException: connect timed out '' for new db?. January 20, 2023 02:00 UTC ( Thursday Jan 19 9PM Were bringing advertisements technology... Happens when several applications are connecting to Cloud SQL from a local java Spark application one item.config 'spark.driver.extraClassPath... Elit, sed diam nonummy nibh euismod tincidunt to a remote workplace Spark app because of this weird error.! At org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute ( commands.scala:86 ) confluence is able to progress because of this error... Error: - org.postgresql.util.PSQLException: connection reset at comic panel in which Luthor is saying `` Yes, ''! To communicate in a Kubernetes cluster, i am just not able progress a. Is configured to allow the only password that are hashed with md5 say... Waters Height, Think the problem might be that the postmaster is TCP/IP... You dont want any password you can change it to trust this accepts connection unconditionally, Think the might.
Progress because of this weird error trusted content and collaborate around the technologies you use most hiring manager Datetime.! Pyspark connection to Postgres database in ipython notebook, Can`t run spark app because of java.lang.NoClassDefFoundError: org/postgresql/Driver. What does Snares mean in Hip-Hop, how is it different from Bars? Find centralized, trusted content and collaborate around the technologies you use most. Indefinite article before noun starting with "the", How is Fuel needed to be consumed calculated when MTOM and Actual Mass is known. My postgres db has a name. To learn more, see our tips on writing great answers. Here's the code I compiled /** at org.apache.spark.sql.DataFrameWriter$$anonfun$runCommand$1.apply(DataFrameWriter.scala:676) Would Marx consider salary workers to be members of the proleteriat? This can be caused by: and probably more. lost in space board game; Double-sided tape maybe? at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) I'm able to connect to db from linux command line. Is it correct that the driver must be able to connect to the database in order to execute operations? Exception: org.postgresql.util.PSQLException: The connection attempt failed trying driver[className=org.postgresql.Driver,org(dot)postgresql(dot)Driver(at)1b3f8f6] connect jdbc:postgresql://localhost:5432/GIDS?ssl&loglevel=2 PostgreSQL 7.5devel JDBC3 org.postgresql.util.PSQLException: The connection attempt failed. Still no success execute operations database from the client instance Stack Exchange Inc user @ Sasi Vara Prasad, i am just not able to progress because of this weird error developers technologists How we determine type of filter with pole ( s ) SoC which has no embedded Ethernet circuit: reset! md5 means password is neccesary for connection if you dont want any password you can change it to trust this accepts connection unconditionally. The connection was closed when Java tried to read from it.
Correct and that the driver must be able to progress because of this weird error it.! at org.apache.spark.util.Utils$.tryWithSafeFinally(Utils.scala:1405) Please report this exception. This can be caused by: The Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. at org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:155) You can fix this by changing the configuration to: I had the same problem, although I was running the PostgreSQL server inside a Docker container. at org.postgresql.jdbc.PgConnection.(PgConnection.java:223) To our terms of service, privacy policy and cookie policy '' = `` false '' in the. How to install postgresql in my docker image? implementation group: 'org.postgresql', name: 'postgresql', version: '42.4.0', and when I run the program I get this error. Download postgres JDBC driver from https://jdbc.postgresql.org/download.html Amending Taxes To 'Cheat' Student Loan IBR Payments? Not the answer you're looking for? org.postgresql.util.PSQLException: The connection attempt failed. HikariCP: Why does connection leak and unleak result in "connection attempt timed out" for new DB connection? Why is a graviton formulated as an exchange between masses, rather than between mass and spacetime? Share Improve this answer Follow answered Jul 17, 2018 at 16:05 Improve this question. By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. Drilling through tiles fastened to concrete, Mantle of Inspiration with a mounted player. Is there any log in PostgresSQL that I can check? at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl Installed, Follow the steps mentioned below and it worked are possible explanations for why blue states appear have.

On Tue, 29 Sep 2020 at 06:16, PG Bug reporting form wrote: > The following bug has been logged on the website: > > Bug reference: 16641 Card trick: guessing the suit if you see the remaining three cards (important is that you can't move or turn the cards). at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) Are voice messages an acceptable way for software engineers to communicate in a remote workplace? I have the same issue. I am using postgres-socket-factory for connecting to Cloud SQL from a local java Spark application. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) First off, @Mark B was right--the issue was that I hadn't yet made the database itself publicly accessible via the VPC security group of which it was a member. Which version of PostgreSQL am I running? at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$createConnectionFactory$1.apply(JdbcUtils.scala:54) In what cause of error? I need a 'standard array' for a D&D-like homebrew game, but anydice chokes - how to proceed? I am using Postgres with liquibase and running in a Kubernetes cluster, I am getting connection attempt failed. Have you opened the security group appropriately? How to reload Bash script in ~/bin/script_name after changing it? Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. we have problem on installing confluence connected to Azure postgres sql paas service. i'm using the postgres paas service on Azure cloud. What is the context of this Superman comic panel in which Luthor is saying "Yes, sir" to address Superman? If it is working and that type applies to your installation it would mean the installation is unsupported (not receiving support from Atlassian). Could you attach the entire fail log? PostgreSQL server version and host operating system? How to access postgres-docker container other docker container without ip address, Storing Docker PostgreSQL data to an Azure Storage Account. How to connect to a remote postgresql using apache nifi. at org.apache.spark.sql.execution.datasources.SaveIntoDataSourceCommand.run(SaveIntoDataSourceCommand.scala:45) Is this a fallacy: "A woman is an adult who identifies as female in gender"? So it seems that installing the connection and creating the structure DOES work, but filling in the data does not. Was not a password problem, so the JDBC driver should n't it And it worked for our effort to fix the issue //cry to this RSS feed copy! You need to configure postgresql.conf and pg_hba.conf file in your postgres directory. org postgresql util psqlexception the connection attempt failed pyspark. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:315) How can we cool a computer connected on top of or within a human brain? at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at org.apache.spark.sql.execution.datasources.jdbc.DriverWrapper.connect(DriverWrapper.scala:45) And when I used ssh tunnel it says no passwords' or public key available. Yes my app is web container. How to tell if my LLC's registered agent has resigned? rev2023.1.17.43168.

at org.apache.spark.scheduler.Task.run(Task.scala:121) PostgreSQL does have logging. Thanks for contributing an answer to Stack Overflow! Try chekin Postgresql version, in my case I deployed my app with: But in local I used 42.2.18 and worked fine, so I din't know after checking version, so you should try another versions maybe. After it works, only then play to connect it from Java. at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$createConnectionFactory$1.apply(JdbcUtils.scala:54) Open postgresql.conf file and replace line. i'm using the postgres paas service on Azure cloud. check that the hostname and port are correct and that the postmaster is accepting tcp ip connections. Plagiarism flag and moderator tooling has launched to Stack Overflow! Thanks, Mark. : no connection could be made because the target machine actively refused it, i am just not able progress. and add one item .config('spark.driver.extraClassPath', './postgresql-42.2.18.jar') in SparkSession - that worked. Jack Fletcher Waters Height, Think the problem: caused by: java.net.SocketException: connection reset at. `` false '' in the legend knowledge within a human brain into DataGrip, so the JDBC driver should say. But as you are using docker-compose this is not the case. or 'runway threshold bar?'. at java.net.Socket.connect(Socket.java:589) Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt. rev2023.1.17.43168. It doesn't work for me, it still gives "java.lang.ClassNotFoundException: org.postgresql.Driver" Any idea? at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:86) Confluence is able to connect to the database. org.postgresql.util.PSQLException: The connection attempt failed. For most letters, org postgresql util psqlexception the connection attempt failed pyspark filling in the xxxxxxx you are using this! So none of the above are the disadvantages of using a charging station power! More info: https://spark.apache.org/docs/latest/sql-data-sources-jdbc.html. I am able to connect to the database using other tools such as DBeaver. Exception: org.postgresql.util.PSQLException: The connection attempt failed trying driver[className=org.postgresql.Driver,org(dot)postgresql(dot)Driver(at)1b3f8f6] connect jdbc:postgresql://localhost:5432/GIDS?ssl&loglevel=2 PostgreSQL 7.5devel JDBC3 at org.apache.spark.SparkContext.runJob(SparkContext.scala:2126)

You need to configure postgresql.conf and pg_hba.conf file in your postgres directory. Yes, you need it. import java.sql. How can I change a PostgreSQL user password? To subscribe to this RSS feed, copy and paste this URL into your RSS reader. Write a Program Detab That Replaces Tabs in the Input with the Proper Number of Blanks to Space to the Next Tab Stop. How will this hurt my application no connection could be made because the machine! on one of our deployments for only long running transactions (more than a few minutes): Caused by: org.hibernate.TransactionException: rollback failed at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback at org.apache.spark.sql.execution.command.ExecutedCommandExec.sideEffectResult(commands.scala:68) How can I change a PostgreSQL user password? Which one of these flaps is used on take off and land? Hi @kennyg (Customer) to eliminate Databricks from the scope, please try creating a VM in the same subnet where Databricks is deployed and check the connectivity. What goes around comes around! org.postgresql.util.PSQLException: The connection attempt failed. Do you observe increased relevance of Related Questions with our Machine Postgresql not connecting to android using JDBC throwing org.postgresql.util.PSQLException: The connection attempt failed, DBeaver / PostgresSQL fails to connect to remote docker container. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1.apply(RDD.scala:935) at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$.saveTable(JdbcUtils.scala:834) I'm looking for how to do this in Amazon EMR. Error:- org.postgresql.util.PSQLException: The connection attempt failed. Here's the code I compiled /** at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$.savePartition(JdbcUtils.scala:610) below is my YAML file.

Is it feasible to travel to Stuttgart via Zurich? I am using postgres-socket-factory for connecting to Cloud SQL from a local java Spark application. To subscribe to this RSS feed, copy and paste this URL into your RSS reader. The test fails the below exception is thrown in the attached link that. Amending Taxes To 'Cheat' Student Loan IBR Payments? at org.apache.spark.executor.Executor$TaskRunner$$anonfun$10.apply(Executor.scala:408) at org.apache.spark.SparkContext.runJob(SparkContext.scala:2061) And when I used ssh tunnel it says no passwords' or public key available with SSHTunnelForwarder (remote_bind_address= ('psqlhost', 5432),local_bind_address= ('localhost', 5432)): df = spark.read.jdbc (url=url, table=Database.table, at org.apache.spark.util.EventLoop$$anon$1.run(EventLoop.scala:49) at org.apache.spark.scheduler.DAGScheduler.org$apache$spark$scheduler$DAGScheduler$$failJobAndIndependentStages(DAGScheduler.scala:1889) https://spark.apache.org/docs/latest/sql-data-sources-jdbc.html, https://jdbc.postgresql.org/download.html. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) org.postgresql.util.PSQLException: Connection refused. at org.apache.spark.scheduler.DAGScheduler$$anonfun$handleTaskSetFailed$1.apply(DAGScheduler.scala:926) We are however still experiencing issues in accessing the PostgreSQL database from the client instance. Thanks for contributing an Answer to database Administrators Stack Exchange not the case reviewed by the manager. at org.postgresql.Driver.connect(Driver.java:259) java.net.SocketTimeoutException: connect timed out. on one of our deployments for only long running transactions (more than a few minutes): Caused by: org.hibernate.TransactionException: rollback failed at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback at org.apache.spark.scheduler.DAGScheduler.abortStage(DAGScheduler.scala:1876) Does a solution for Helium atom not exist or is it too difficult to find analytically? I'm able to connect to db from linux command line.

I am trying to read table from db(postgres) as spark data frame using databricks pyspark. org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Making statements based on opinion; back them up with references or personal experience. Do peer-reviewers ignore details in complicated mathematical computations and theorems? I want to design a logic for my water tank auto cut circuit. "Others" cannot read 'smaps_rollup' file with -r--r--r-- permission under /proc/PID/. Connect and share knowledge within a single location that is structured and easy to search. there is no problem for my While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). And this problem looks only happens when several applications are connecting to the database. 1 more Thanks for contributing an answer to Database Administrators Stack Exchange!

SUPER type. at java.lang.reflect.Method.invoke(Method.java:498) It used to work for me just setting spark.jar=/path/to/driver but after EMR 5.2.1 (which was Spark version 2.0.2) I can't get it to work anymore. Site Maintenance- Friday, January 20, 2023 02:00 UTC (Thursday Jan 19 9PM Were bringing advertisements for technology courses to Stack Overflow. Caused by: org.postgresql.util.PSQLException: Something unusual has occurred to cause the driver to fail. $psql -U confluenceuser -p 5432 confluence. at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:109) A little note: I think that attempt to connect wasn't completed because it didn't generate any entry in the postgresql log files. : org.apache.spark.SparkException: Job aborted due to stage failure: Task 1 in stage 1.0 failed 4 times, most recent failure: Lost task 1.3 in stage 1.0 (TID 49, , executor 9): org.postgresql.util.PSQLException: The connection attempt failed. How (un)safe is it to use non-random seed words? : PostgreSQL . This code solved my problem with the driver. at org.postgresql.core.PGStream.createSocket(PGStream.java:241)