dwyl / learn-postgresql

🐘 Learn how to use PostgreSQL and Structured Query Language (SQL) to store and query your relational data. 🔍
211 stars 23 forks source link

Postgres App: Binaries not found #79

Closed nelsonic closed 3 years ago

nelsonic commented 3 years ago

Updated to Postgres-2.4.3-13.dmg which includes PostgreSQL v13 https://postgresapp.com/downloads.html

Sadly, seeing the "Binaries not found" error:

image

Need this in order to run Phoenix Apps ... https://github.com/dwyl/auth/issues/145 (busy upgrading the auth app ...)

nelsonic commented 3 years ago

Solution: https://github.com/PostgresApp/PostgresApp/issues/517#issuecomment-611693914

"solved it by opening up the application's sliding windows, then clicked a new server with the plus icon, then that had initialization button, then clicked initialise than it worked."

referenced by: https://stackoverflow.com/questions/60365429/resolve-binaries-not-found-error-in-postgres-app (upvoted)

image

Expanded:

Screenshot 2021-05-24 at 11 50 47

Create new server: Screenshot 2021-05-24 at 15 39 58

Called it PG13 image

Now it says "Empty data directory":

image

Click the "initialize" button, and then it will work:

image

done

Also this is worth reading for future reference: https://stillriversoftware.com/blog/upgrading-postgres-app-without-shooting-yourself-in-the-foot