PostgreSQL一些簡單問題以及解決辦法

問題：
org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
解決辦法：Edit /var/lib/pgsql/data/postgresql.conf file
Change
#listen_addresses = 'localhost'
to
listen_addresses = '*'

問題：
org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "<host_ip>", user "fkong", database "fkong", SSL off
解決辦法：
Edit /var/lib/pgsql/data/pg_hba.conf file
Add below line under "# IPv4 local connections:"
"host    all         all         <host_ip>/32         password"

問題：
org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "fkong"
解決辦法：
Edit /var/lib/pgsql/data/pg_hba.conf file
Change
"host    all         all         <host_ip>/32         ident"
to
"host    all         all         <host_ip>/32         password"