【0033】 PostgreSQL报错: psql: could not connect to server: No such file or directory

时间:2025-02-09 17:08:58

    psql命令终端登录PostgreSQL服务器时候报错,并提示一下错误信息:

[root@mdw bin]# ./psql -p 5432 -U postgres;
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/..5432"?

    登录时候添加上PostgreSQL服务的ip地址,如下:
    [root@mdw bin]# ./psql -p 5432 -U postgres -h 127.0.0.1;
    就可以了。