In case people can't determine if Postgresql is running with lsof -i :5432

[Leo328]

Hi there,

This is my first ever open-source contribution post on GitHub. I'm super-new at this but also want to make sure others don't get stuck with frustrating issues when learning.

I noticed that when going through the tutorial, there was a recommendation to use lsof -i :5432 to check if Postgresql was running correctly. This didn't work for me (there was no output), but I do know that Postgres was running as I had just successfully created a new DB with Ecto.

Instead, I used pg_isready and got the desired confirmation:

For context, I am running Ubuntu 18.04 through WSL2 with Postgresql-12.

Cheers,
Leo.

[nelsonic]

@Leo328 great addition.

pg_isready
/tmp:5432 - accepting connections

Works on Mac too. ✅

[nelsonic]

@LuchoTurtle please add the pg_isread command to the https://github.com/dwyl/phoenix-chat-example#check-you-have-everything-before-starting section during your update #149 🙏

[nelsonic]

Just tried to run:

pg_isready

On my M1 mac and ...

Got:

zsh: command not found: pg_isready

[LuchoTurtle]

Weird that it was working on your Mac prior and not anymore.
It comes with psql, weird that you get a not found error.

[nelsonic]

Yeah, thought it was weird too… hence capturing in case anyone else faces this in the future … ⏳