To install Postgres.app, just drag it to your Applications folder and double click.
Postgres.app must be placed in the /Applications folder, and you can’t rename it. The reason for this is that it includes a lot of dynamic libraries that can be used by other software. These libraries can’t be found if you change the path.
If you’d like to use the command line tools delivered with Postgres.app, execute the following command in Terminal to configure your
$PATH, and then close & reopen the window:
sudo mkdir -p /etc/paths.d && echo /Applications/Postgres.app/Contents/Versions/latest/bin | sudo tee /etc/paths.d/postgresapp
For more details, see the section on Command Line Tools.
~/Library/Application Support/Postgres/var-XX(XX is the major version of PostgreSQL)
defaults delete com.postgresapp.Postgres2
$PATHconfig for the command line tools (optional):
sudo rm /etc/paths.d/postgresapp