psql命令没有响应

Question

当我单独运行psql命令(没有参数，安装postgres-10，从Debian Sid运行)时，它一直保持空白并永远运行。我尝试用systemctl status postgresql检查状态，结果显示服务器处于活动状态。当我通过将host指定为localhost来运行它时，它也会执行同样的操作。

这是我的postgresql.conf文件的连接设置部分：

 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 = 100          # (change requires restart)
 # Note:  Increasing max_connections costs ~400 bytes of shared memory per
 # connection slot, plus lock space (see max_locks_per_transaction).
 #superuser_reserved_connections = 3    # (change requires restart)
 unix_socket_directories = '/var/run/postgresql'    # comma-separated list of directories
                # (change requires restart)
 #unix_socket_group = ''            # (change requires restart)
 #unix_socket_permissions = 0777        # begin with 0 to use octal notation
                # (change requires restart)
 #bonjour = off             # advertise server via Bonjour
                # (change requires restart)
 #bonjour = on # MJB                    
 #bonjour_name = ''         # defaults to the computer name
                # (change requires restart)

 # - Security and Authentication -

 #authentication_timeout = 1min     # 1s-600s
 ssl = true             # (change requires restart)
 #ssl_ciphers = 'HIGH:MEDIUM:+3DES:!aNULL' # allowed SSL ciphers
                # (change requires restart)
 #ssl_prefer_server_ciphers = on        # (change requires restart)
 #ssl_ecdh_curve = 'prime256v1'     # (change requires restart)
 #ssl_renegotiation_limit = 512MB   # amount of data between renegotiations
 ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem'     # (change requires restart)
 ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key'        # (change requires restart)
 #ssl_ca_file = ''          # (change requires restart)
 #ssl_crl_file = ''         # (change requires restart)
 #password_encryption = on
 #db_user_namespace = off

 # GSSAPI using Kerberos
 #krb_server_keyfile = ''
 #krb_caseins_users = off

 # - TCP Keepalives -
 # see "man 7 tcp" for details

 #tcp_keepalives_idle = 0       # TCP_KEEPIDLE, in seconds;
                # 0 selects the system default
 #tcp_keepalives_interval = 0       # TCP_KEEPINTVL, in seconds;
                # 0 selects the system default
 #tcp_keepalives_count = 0      # TCP_KEEPCNT;
                # 0 selects the system default

为了解决这个问题，我应该去哪里寻找？

Answer 1

所以我们可能需要更多的信息。你正在下载一个终端并运行psql吗？如果是这样的话，你是不是只运行没有参数的psql (即$ psql <enter>

当您单独运行psql命令时，它将尝试通过套接字或127.0.0.1连接到Postgres服务器。如果它挂起，它可能正在尝试连接到127.0.0.1，并且防火墙正在丢弃数据包，或者没有任何响应，从而导致它挂起。如果您等待的时间足够长，它应该会超时。

也许更好的问题是“你期望发生什么？”是否有Postgres服务器运行在与终端相同的机器上？你确定它在运行吗？它是否安装了服务？如果是这样，sudo systemctl status postgresql-10是否表明它正在运行？如果运行psql -h 127.0.0.1会发生什么？Postgres是否配置为侦听网络接口？是否有防火墙拦截端口5432？Postgres是否在端口5432上运行？

...And潜在问题的列表还在继续。试着给上面的问题找出一些答案。你的问题相当于“我的车坏了--出什么问题了？”；我们需要更多的信息来帮助你解决问题。:)