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