How to resolve PostgreSQL port 5432 Error:Server already in use? | How to install PostgreSQL? | Mac

Please watch complete video to understand and resolve PostgreSQL 5432 port server connectivity issue (port already in use).
Download link: postgresapp.com
please Run below command before starting the PostgreSQL :
sudo mkdir -p /etc/paths.d &&
echo /Applications/Postgres.app/Contents/Versions/latest/bin | sudo tee /etc/paths.d/postgresapp

[@skullcrusher5913]

hey, i wanted to point this out, "that u should never kill -9 a postgresql process", this will leave locked files preventing your database from running

[@nikitaparshin_nsk]

Big thanks from Russia❤

[@sanketsharma2275]

Hi Supriya,
How can I find this on MacBook Pro?
Not able to locate this GUI for starting the server manually

[@supriyabandal6033]

Hi sanket, for GUI i used pgAdmin. All the commands I have used should be absolutely same for Macbook Pro. you can follow: step-1: get the list of processes running on your machine using " sudo lsof -i : ". step-2: kill the process using " sudo kill -9 . step-3: restart your pc .

[@karnavchahwala4354]

Great going Sup 👍✌.. Keep making more videos

[@MonishC-n3u]

Thank you so much it heals me more

[@bwanapia]

Thanks for your help. this is the closest video i have to resolving my 5433 connection refused. However this didnt work for me. the sudo lsof -i : 5433 didnt work for me, as the error code mine is 5433. please help me with a simpler steps please. thanks

[@supriyabandal6033]

This video is for Mac users. step-1: get the list of processes running on your machine using " sudo lsof -i : ". step-2: kill the process using " sudo kill -9 . step-3: restart your pc . If still issue persists then uninstall the PG and reinstall. hope that helps.

[@soundarb8683]

Mam I got this error.."http status 500 - internal server error type exception report message could not initialize class org.postgresql.util.urlcoder ". How to resolve..

[@hamidkhura9390]

Thank you for your help. I have this issues but this didn't work for me. my machine is macbook pro m1, pleas help me to solve my problem. thank you

[@princearthur5532]

it worked 🙏

[@mahendraj6441]

Great job ..

[@nanakwaku101]

Thanks for putting up this great video . I have issue concerning permission denied whenever I try copying CSV file on my local postgres. Please any tip on resolving this issue

[@supriyabandal6033]

You can check the permissions by running ls -l /path/to/file.csv. If the permissions are incorrect, you can modify them by running chmod +r /path/to/file.csv.

[@shubhamtaksande3052]

zsh commond not found : sudo

[@subhashbandal6780]

Nice work

[@sanketsharma2275]

Hi Supriya,