Psql could not connect to server: No such file or directory, 5432 error?

I’ve had this same issue, related to the configuration of my pg_hba.conf file (located in /etc/postgresql/9.6/main). Please note that 9.6 is the postgresql version I am using.

The error itself is related to a misconfiguration of postgresql, which causes the server to crash before it starts.

I would suggest following these instructions:

  1. Certify that postgresql service is running, using sudo service postgresql start
  2. Run pg_lsclusters from your terminal
  3. Check what is the cluster you are running, the output should be something like:Version – Cluster Port Status Owner Data directory9.6 ——- main — 5432 online postgres /var/lib/postgresql/9.6/mainDisregard the ‘—‘ signs, as they are being used there only for alignment. The important information are the version and the cluster. You can also check whether the server is running or not in the status column.
  4. Copy the info from the version and the cluster, and use like so: pg_ctlcluster <version> <cluster> start, so in my case, using version 9.6 and cluster ‘main’, it would be pg_ctlcluster 9.6 main start
  5. If something is wrong, then postgresql will generate a log, that can be accessed on /var/log/postgresql/postgresql-<version>-main.log, so in my case, the full command would be sudo nano /var/log/postgresql/postgresql-9.6-main.log.
  6. The output should show what is the error.2017-07-13 16:53:04 BRT [32176-1] LOG: invalid authentication method “all”
    2017-07-13 16:53:04 BRT [32176-2] CONTEXT: line 90 of configuration file “/etc/postgresql/9.5/main/pg_hba.conf”
    2017-07-13 16:53:04 BRT [32176-3] FATAL: could not load pg_hba.conf
  7. Fix the errors and restart postgresql service through sudo service postgresql restart and it should be fine.

I have searched a lot to find this, credit goes to this post.

Best of luck!

Related Posts:

  1. PostgreSQL: Show tables in PostgreSQL
  2. Getting error: Peer authentication failed for user “postgres”, when trying to get pgsql working with rails
  3. What is the format for the PostgreSQL connection string / URL?
  4. “use database_name” command in PostgreSQL
  5. PSQLException: current transaction is aborted, commands ignored until end of transaction block
  6. psql: FATAL: Ident authentication failed for user “postgres”
  7. fe_sendauth: no password supplied
  8. How can I drop all the tables in a PostgreSQL database?
  9. How to restart PostgreSQL in Ubuntu 18.04
  10. FATAL: password authentication failed for user “postgres” (postgresql 11 with pgAdmin 4)
  11. Postgresql: Scripting psql execution with password
  12. postgresql duplicate key violates unique constraint
  13. “psql: could not connect to server: Connection refused” Error when connecting to remote database
  14. How to change PostgreSQL user password?
  15. No function matches the given name and argument types
  16. PostgreSQL error: Fatal: role “username” does not exist
  17. How to change PostgreSQL user password?
  18. How to exit from PostgreSQL command line utility: psql
  19. psql: FATAL: database “” does not exist
  20. eroku “psql: FATAL: remaining connection slots are reserved for non-replication superuser connections”
  21. Permission denied for relation
  22. postgres does not know where to find server configuration
  23. input file appears to be a text format dump. Please use psql
  24. PG COPY error: invalid input syntax for integer
  25. Postgres: INSERT if does not exist already
  26. What’s the default superuser username/password for postgres after a new install?
  27. How to see active connections and “current activity” in PostgreSQL 8.4
  28. pg_dump and pg_restore: input file does not appear to be a valid archive
  29. What is this JavaScript “require”?
  30. What is this JavaScript “require”?
  31. PostgreSQL “DESCRIBE TABLE”
  32. How to UPSERT (MERGE, INSERT … ON DUPLICATE UPDATE) in PostgreSQL?
  33. How to restart Postgresql
  34. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  35. What is the default password for Postgres
  36. Postgresql 9.2 pg_dump version mismatch
  37. missing FROM-clause entry for table
  38. PostgreSQL: Remotely connecting to Postgres instance using psql command
  39. Simple Random Samples from a Sql database
  40. Insert text with single quotes in PostgreSQL
  41. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  42. Cannot simply use PostgreSQL table name (“relation does not exist”)
  43. Can’t find the ‘libpq-fe.h header when trying to install pg gem
  44. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  45. could not connect to server: No such file or directory (PG::ConnectionBad)
  46. Postgresql tables exists, but getting “relation does not exist” when querying
  47. PG::ConnectionBad: fe_sendauth: no password supplied
  48. “extra data after last expected column” while trying to import a csv file into postgresql
  49. postgresql: error duplicate key value violates unique constraint
  50. psql: command not found Mac
  51. pg_ctl: no database directory specified and environment variable PGDATA unset
  52. psql: FATAL: role “postgres” does not exist
  53. Postgres Error: More than one row returned by a subquery used as an expression
  54. PostgreSQL: Query has no destination for result data
  55. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  56. PostgreSQL create table if not exists
  57. SSH to Vagrant box in Windows?
  58. updating table rows in postgres using subquery
  59. PostgreSQL visual interface similar to phpMyAdmin?
  60. java.lang.ClassNotFoundException: org.postgresql.Driver, Android
  61. GROUP BY and COUNT using ActiveRecord
  62. Postgresql column reference “id” is ambiguous
  63. VBoxManage: error: Failed to create the host-only adapter (II)
  64. What is a postgres superuser
  65. Vagrant script to setup all the common PHP / WordPress version combinations
  66. NGinx + WordPress Subdomain Multi with core in Subdirectory
  67. Symlink a directory to wp-content/themes
  68. WordPress Multisite with VVV
  69. WordPress development using Docker – how to share directories? [closed]
  70. Local install won’t work without internet
  71. Multisite setup on VVV with bedrock
  72. Version control for both Vagrant config and themes being developed [closed]
  73. docker on windows 10 with VVV [closed]
  74. xdebug connects but won’t break in WordPress with vvv
  75. Parse error syntax error after WordPress update
  76. Permalinks not working with Vagrant
  77. Plugin updated pushed with git break site
  78. Unable to access WordPress server locally running using vagrant
  79. Vagrant Access index.php
  80. GRANT SELECT to all tables in postgresql
  81. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  82. Postgres equivalent to MySQL’s \G?
  83. Postgresql: what does GRANT ALL PRIVILEGES ON DATABASE do?
  84. Postgres equivalent to MySQL’s \G?
  85. Postgres equivalent to MySQL’s \G?
  86. dpkg-reconfigure: unable to re-open stdin: No file or directory
  87. Vagrant / VirtualBox DNS 10.0.2.3 not working

Leave a Comment