I have found the solution

Solution 1

# add the two line to the SparkSession.builder
.config("spark.driver.extraClassPath", "/path/to/postgresql-42.7.3.jar") \
.config("spark.executor.extraClassPath", "/path/to/postgresql-42.7.3.jar") \

Solution 2

copy your postgresql-xx.x.x.jar "postgresql-42.7.4.jar" to python site packages pyspark jars path

/usr/local/lib/python3.9/site-packages/pyspark/jars