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

I've had this same issue, related vĩ đại the configuration of my pg_hba.conf tệp tin (located in /etc/postgresql/9.6/main). Please note that 9.6 is the postgresql version I am using.

The error itself is related vĩ đại a misconfiguration of postgresql, which causes the server vĩ đại 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 directory

   9.6 ------- main -- 5432 online postgres /var/lib/postgresql/9.6/main

   Disregard the '---' signs, as they are being used there only for alignment. The important information are the version and the cluster. You can also kiểm tra whether the server is running or not in the status column.

4. Copy the info from the version and the cluster, and use lượt thích so: pg_ctlcluster start, sánh 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--main.log, sánh 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 tệp tin "/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 vĩ đại find this, credit goes vĩ đại this post.

Best of luck!

answered Jun 23, 2018 at 11:35

martinlasekmartinlasek

8921 gold badge8 silver badges9 bronze badges

These two steps solved it for bu on Mac:

rm /usr/local/var/postgres/postmaster.pid
brew services restart postgresql

For M1 Macs:

rm /opt/homebrew/var/postgres/postmaster.pid
brew services restart postgresql

In case you face this issue (reported by @luckyguy73): psql: FATAL: database "postgresql" does not exist

You can run

brew postgresql-upgrade-database

to fix it.

I am just posting this for anyone who is feeling lost and hopeless as I did when I found this question. It seems that sometimes by editing some psotgresql-related config files, one can accidentally change the permissions of the file:

Note how pg_hba.conf belongs vĩ đại root, and users cannot even read it. This causes postgres vĩ đại not be able vĩ đại open this tệp tin and therefore not be able vĩ đại start the server, throwing the error seen in the original question.

By running

sudo chmod +r pg_hba.conf

I was able vĩ đại make this tệp tin once again accessible vĩ đại the postgres user and then after running

sudo service postgresql start

Was able vĩ đại get the server running again.

WARNING: This will remove the database

Use command:

rm -rf /usr/local/var/postgres && initdb /usr/local/var/postgres -E utf8

answered Mar 7, 2017 at 17:52

J2112OJ2112O

6353 gold badges11 silver badges25 bronze badges

I was able vĩ đại solve the issue by running:

sudo systemctl start [email protected]

answered Apr 2, 2021 at 12:54

Denis PDenis P

7669 silver badges12 bronze badges

answered Sep 14, 2018 at 7:53

answered Jan 23, 2020 at 5:38

horoyoi ohoroyoi o

6821 gold badge9 silver badges33 bronze badges

answered Jul 17, 2020 at 10:54

Sushin PvSushin Pv

1,8844 gold badges25 silver badges36 bronze badges

I occasionally have the same issue but mostly after macOS upgrades. Shutting down and migrating vĩ đại the new version usually fixes it for me(make changes according vĩ đại your version). So first upgrade your postgresql

brew services stop postgresql@12
brew services start postgresql@12
brew postgresql-upgrade-database

This is mostly a temporary fix but since I couldn't find a better solution this works for bu.

Update: If the issue says that another postmaster is running then try removing it from that location(your postmaster.pid location will be displayed vĩ đại you)

rm /usr/local/var/postgres/postmaster.pid

Ubuntu 20

This Problem happened vĩ đại bu, as ubuntu pre-installed version of Postgresql-9.6 server was always down and after trying all the above answers it didn't start.

Solution:

1. I installed another version of Postgresql which is postgresql-13, using this command: sudo apt install postgresql it will install the latest version of postgresql.

2. I see if the server is online or down using this command: pg_lsclusters if the new version of postgresql is online, we will proceed vĩ đại remove the old version of postgresql.

3. we will see all packages that are installed related vĩ đại postgresql, using this command: dpkg -l | grep postgresql

4. Remove the old version, which is here postgresql-9.6. Using this command: sudo apt-get --purge remove postgresql-9.6 postgresql-client-9.6 replace 9.6 with your old version number. Final remaining packages related vĩ đại the latest Version 13:

5. Restart your postgresql latest version server, which is here postgresql-13. Using this command: sudo systemctl restart postgresql@13-main replace 13 in the command with your latest version number.

6. Now, if you try psql command you will get an error related vĩ đại your user, as in the image:

7. To Remove the above error, The installation procedure created a user tài khoản called postgres that is associated with the mặc định Postgres role, vĩ đại switch over vĩ đại the postgres tài khoản use this command: sudo -u postgres psql this command will log you into the interactive Postgres session. You can also phối your password for this user using this command \password postgres.

8. Then change the Port vĩ đại the deafult port of postgresql, which is 5432 as all application will try vĩ đại connect vĩ đại postgresql using this port by mặc định, using this command: sudo nano /etc/postgresql/13/main/postgresql.conf, it will open postgresql configuration tệp tin, then tìm kiếm for port and change it vĩ đại 5432. After that you need vĩ đại restart the server using this command sudo systemctl restart postgresql@13-main. Note, Replace 13 in the command with your latest version.

If you want vĩ đại create your own User/Role, use this command: sudo -u postgres createuser --interactive. The script will prompt you with some choices, as in the image and based on your responses, it will execute the correct Postgres commands vĩ đại create a user vĩ đại your specifications.

Tutorial: For more information on postgresql related commands

answered Aug 5, 2017 at 7:57

answered Jan 29, 2018 at 1:58

CENTURIONCENTURION

3634 silver badges11 bronze badges

answered Jan 31, 2018 at 7:29

ranvirranvir

1161 silver badge7 bronze badges

answered Sep 17, 2019 at 13:08

ShiwanginiShiwangini

8341 gold badge18 silver badges33 bronze badges

answered Jan 5, 2020 at 15:35

muceyMucemuceyMuce

1192 gold badges2 silver badges8 bronze badges

answered Jun 8, 2020 at 7:32

umunBeingumunBeing

6611 gold badge7 silver badges15 bronze badges

answered Jul 7, 2021 at 11:37

I faced the same issue.

So i checked for the logs

sudo tail -f /var/log/postgresql/postgresql-14-main.log (14 -> version of installed)

output as below

Examine the log output.
2023-04-05 19:43:16.884 +0530 [7097] FATAL:  could not open log tệp tin "/var/log/postgresql/logs/postgresql-2023-04-05.log": Permission denied
2023-04-05 19:43:16.886 +0530 [7097] LOG:  database system is shut down
pg_ctl: could not start server

after i checked for the log tệp tin permission

ls -ld /var/log/postgresql/logs
drw-r----- 2 postgres postgres 4096 Jan 29 09:18 /var/log/postgresql/logs

I excuted below commands

sudo chown postgres:postgres /var/log/postgresql/logs
sudo chmod 750 /var/log/postgresql/logs
sudo systemctl restart postgresql
sudo -u postgres psql

I was able fix the issue.

answered Nov 11, 2020 at 20:49

DharmaDharma

2,6134 gold badges28 silver badges41 bronze badges

answered Nov 28, 2020 at 20:29

ThomasThomas

2,9541 gold badge12 silver badges19 bronze badges

answered Apr 3, 2021 at 14:19

kali users pls tự this

sudo service postgresql restart