Postgres.app For Mac

Postgres.app is an user friendly Mac app designed to help you deploy the PostgreSQL database management system on your computer in no time, with minimal user interaction.

Moreover, Postgres.app will automatically create a new database cluster, and a database which can be managed via an unobtrusive status bar menu.

To install the Postgres.app utility on your computer, all you have to do is drag and drop its icon to the Application’s directory. The archive includes all you might need to run a PostgreSQL server right out of the box.

For your convenience, Postgres.app will place a menu in your status bar that displays the port used by the PostgreSQL server, and allows you to open the psql command line tools in your Terminal. Finding your way around the Postgres.app app is fairly intuitive.

Postgres.app includes several command line tools that can be employed to manage your database server: PostgreSQL, PROJ.4, GDAL, and PostGIS. You can easily employ the psql command-line interface.

Postgres.app can connect to any graphical user interface developed for PostgreSQL database servers. All you have to do is provide the details for certain parameters, such as the host name (localhost), the port number (5432 is the default value), the user name (your user name), the password (leave blank), and the database name (is the same as the username).

Postgres.app proposes a simple solution for deploying PostgreSQL on your Mac and generating a database that can be managed using the command line, or various PostgreSQL GUI clients.

The best part is that Postgres.app does not require any user interaction in setting up the server: the app starts the server at launch, and stops the server when you quit the utility.