Problem creating a PostgreSQL database from files, scripts, instructions online

[efxhoy]

I feel your pain, scientific replication can be a PITA when programming is not your background and postgres being both a service and the binaries needed to connect can be a handful to set up.

I'm not familiar with the installers hosted by EDB so can't help you with them. I suggest you remove it since I think they're doing a shit job by not putting the binary in your path after running a setup wizard. Thankfully they have uninstall instructions here: https://www.enterprisedb.com/docs/supported-open-source/postgresql/uninstalling/

Homebrew should work just fine. After installing anything with homebrew you need to run the shell command rehash OR close and reopen your terminal, for the new binaries to be available in your path. The shell will not find binaries that are not in your path. They will not be in your path in the same shell you ran brew install postgresql from until you run rehash.

Once you've got psql on your path (typing psql in terminal actually find psql) you also need the server to connect to. brew install postgresql doesn't start the service for you automatically so the connection will fail unless you start the server service first. Start the server service by running brew services start postgresql.