Postgres.app port in use

Question

I am trying to start the server and getting an error

Port 5432 is already in use

I have brew uninstall postgress

which postgres

gives me nothing.

Activity monitor has 14 postgres processes which I cannot kill. Force quit kill the process and restarts it with another pid. The same with sudo kill -9 PID it kills the process and restarts it with another PID.

olegtaranenko · Accepted Answer · 2019-06-30 11:04:05Z

28

If you are running into this problem on OSX, do the following:

Find out what is running on that port:

    $ lsof -n -i4TCP:5432

    COMMAND     PID         USER   FD   TYPE             DEVICE SIZE/OFF NODE NAME
    python2.7 28687 afdasdfasd    3u  IPv4 0x2f18e1284963d3e3      0t0  TCP 127.0.0.1:54970->127.0.0.1:postgresql (CLOSE_WAIT)

Kill it

    $ kill -9 28687

Restart postgresapp

edited Jun 30, 2019 at 11:04

olegtaranenko

3,9803 gold badges31 silver badges35 bronze badges

answered Jul 11, 2017 at 13:48

josephmisiti

10k13 gold badges58 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

leo Over a year ago

The command lsof -n -i4TCP:5432 did the trick for me, "netstat" didn't yield anything for port 5432 on OSX. Thanks!

Oscar Calderon Over a year ago

This one worked for me as well. In my case, I found out I was using DataGrip, and it seems it kept the port in use even when PostgreSQL was not running anymore.

clemens · Accepted Answer · 2018-08-05 17:29:23Z

23

Have you checked for a launch daemon? It controls the Postgres process when Postgres is installed with Homebrew, and it automatically restarts Postgres after it is killed. Try

sudo launchctl list

or

sudo launchctl list | fgrep postg

to find the name of the daemon. You can stop the daemon with sudo launchctl stop <name> where name depends on the result of the first command.

edited Aug 5, 2018 at 17:29

answered Feb 23, 2017 at 14:07

clemens

17.9k12 gold badges52 silver badges71 bronze badges

Comments

tread · Accepted Answer · 2023-03-14 05:19:09Z

20

Askubuntu provided an answer that worked:

sudo pkill -u postgres

Source: Nicely stop all postgres processes

edited Mar 14, 2023 at 5:19

answered Aug 5, 2018 at 15:33

tread

11.3k19 gold badges108 silver badges180 bronze badges

2 Comments

clemens Over a year ago

The OP runs Postgres under MacOS (the Activity Manager is a very subtle hint for that) from the Homebrew package. Homebrew uses launchctl to start and stop Postgres. If you stop Postgres with kill, it will be restarted by launchctl. The OP has already tried your solution without luck.

tread Over a year ago

Alright, but I came to this question because I needed an answer and there is no explicit mention of homebrew. So for others that come to this question, my solution may be a better fit.

Roger Camps · Accepted Answer · 2018-10-23 21:41:47Z

12

$ brew services stop postgresql

This will kill all processes and let you start the server.

answered Oct 23, 2018 at 21:41

Roger Camps

1491 silver badge7 bronze badges

Comments

the Tin Man · Accepted Answer · 2020-05-05 04:52:05Z

3

You can get the list of ports using:

sudo launchctl list

Then enter the application name, and using this command to get the port nunber:

sudo launchctl list | fgrep postg

In my case, the port is 83. Now use:

kill 83

then

sudo kill 5432

edited May 5, 2020 at 4:52

the Tin Man

161k44 gold badges222 silver badges308 bronze badges

answered May 5, 2020 at 3:13

Sarabjeet Singh

1271 silver badge4 bronze badges

Comments

Suraj Malgave · Accepted Answer · 2022-01-14 07:14:45Z

0

Run those commands

To check what is running on port 5432 - $ sudo lsof -i :5432
To kill Postgres - $ sudo pkill -u postgres

answered Jan 14, 2022 at 7:14

Suraj Malgave

1931 silver badge4 bronze badges

Comments

Mana Sh · Accepted Answer · 2022-07-13 05:37:00Z

-1

Use this:

brew services stop postgresql

Good luck!

answered Jul 13, 2022 at 5:37

Mana Sh

11 bronze badge

1 Comment

snakecharmerb Over a year ago

This solution is already provided in this existing answer. When answering old questions please ensure that your answer provides a distinct and valuable contribution to the Q&A.

Collectives™ on Stack Overflow

Postgres.app port in use

7 Answers 7

2 Comments

Comments

2 Comments

Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

2 Comments

Comments

2 Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related