Setting up Postgres 17 on MacOS

Lets use postgresapp to install postgres 17 Download postgres 17 from here Install postgresapp by moving the application to the Applications folder and run it Note: if you already have postgres installed, change the port to non-default port(ex: 5433) Configure the PATH, open terminal and run the following command sudo mkdir -p /etc/paths.d && echo /Applications/Postgres.app/Contents/Versions/latest/bin | sudo tee /etc/paths.d/postgresapp