PostgreSQL一些簡(jiǎn)單問(wèn)題以及解決辦法

問(wèn)題：
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 = '*'

問(wèn)題：
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"

問(wèn)題：
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"

服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]