问题:
最近在服务器上安装了一个psotgresql14,在本机的pgadmin和java项目里想通过服务器的ip:端口连接数据库,总是连接不上。并且在服务器上也只能通过localhost连接
解决方案:
vi /var/lib/pgsql/14/data/postgresql.conf
修改一下监听端口就行了,改完记得解注释!!!(我就是因为改完没有解注释,出问题了)
#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------
# - Connection Settings -
listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost'; use '*' for all
# (change requires restart)
port = 5432 # (change requires restart)
max_connections = 1000 # (change requires restart)
#superuser_reserved_connections = 3 # (change requires restart)
#unix_socket_directories = '/var/run/postgresql, /tmp' # comma-separated list of directories
按需设置最大连接数,默认100。