I m having trouble running prefect server on my local machin

Question

I m having trouble running prefect server on my local machine MBP with intel processor I believe it s run successfully before but today I m getting this error message `Error response from daemon Ports are not available listen tcp 127 0 0 1 5432 bind address already in use` I ve tried restarting the computer reinstalling docker desktop and making a fresh conda environment with a fresh installation of prefect but the error persists When I run `lsof i 5432` I get no output Any ideas for next troubleshooting steps

Jake Kaplan · Answer

Hey Paul outside of Prefect do you run postgres on your local machine normally

Jake Kaplan · Answer

For example I installed postgres using homebrew and it normally runs on startup of my machine in the background ``` ~ brew services Name Status User Plist postgresql started jakekaplan Users jakekaplan Library LaunchAgents homebrew mxcl postgresql plist``` And I get your same error if I do not stop postgres since it defaults to `5432`

Paul Schale · Answer

No it doesn t appear to be running ```$ brew services list Name Status User Plist emacs stopped postgresql stopped ```

Paul Schale · Answer

But that made me realize I can specify a different port for postgres running `prefect server start postgres port 5433` works

Jake Kaplan · Answer

I m sorry I couldn t help you find the initial issue but I m glad you re able to find a workaround