If you see the above error, open pg_hba.conf file (/var/lib/pgsql/data/pg_hba.conf) and uncomment or add the line :local all all trust Then restart postgresql# /etc/init.d/postgresql restart
Category: PostgreSQL
phpPgAdmin Login Failed
If you are unable to login to phpPgAdmin using your Cpanel username and password and getting a “Login failed” message do the following :SSH to your server as root and open /var/lib/pgsql/data/pg_hba.confSearch for# “local” is for Unix domain socket connections onlylocal all all ident sameuserChange it to # “local” is for Unix domain socket connections […]
psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket “/tmp/.s.PGSQL.5432”?
First check if PostgreSQL is running on the server using ps command.#ps aux | grep postgrepostgres 4335 2.4 0.2 27704 2936 ? S 12:07 0:00 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/datapostgres 4337 0.0 0.0 9972 548 ? S 12:07 0:00 postgres: logger processpostgres 4339 0.0 0.0 27704 804 ? S 12:07 0:00 postgres: writer processpostgres 4340 […]