A Mac OS X System Preferences pane for controlling the PostgreSQL Database Server.
Compatible with all PostgreSQL installations - includingHomebrew and One click installer
Start and stop PostgreSQL Servers at the click of a button - no need for obscure commands
Set PostgreSQL to start automatically on computer bootup or user login
Easily change PostgreSQL settings in the GUI
Control multiple PostgreSQL servers in the same window - NEW IN v2.x
Download the latest release versionhere
Once downloaded, unzip it and then either double-click the
PostgreSQL.prefPanefile, or drag it to System Preferences to install it.
When installing, you will be asked if you want to install it for this user only, or for all users. Choose this user only (either option is fine however).
Remove from System Preferences
Right-click on the
PostgreSQL iconin System Preferences, and click
Delete any files named
org.postgresql.preferences.*.plistin the following directories:
Delete the following log directories if they exist:
In a nutshell, what does this tool do and what does it not do?
It can start and stop PostgreSQL servers, show their running status, and schedule auto-startup at boot/login. It cannot install PostgreSQL, create database clusters, create databases or run SQL.
Can I run multiple instances of PostgreSQL on the same machine?
Yes - this is new with Version 2! Note that each separate instance of PostgreSQL must have its own data directory and port. It is easy to specify a different port using the settings popup. But to create a separate data directory you must run the
initdbcommand to create a new database cluster, as described in the PostgreSQL documentation.
PostgreSQL does not start up.
If you clicked
Start PostgreSQL, and the server is stuck with status
Retrying..., the first step is to click the
View Logbutton. This will open the default log for the server in Mac OS X's
Consolelog-viewing application. From the log messages, it should be clear what the problem is. For example, the PostgreSQL data directory or port may already be in use by another server.
I have selected startup at Login/Boot, but PostgreSQL still does not startup automatically.
First, make sure you can start the server manually using the
Start PostgreSQLbutton. If this works ok, then please file an issue on github and we will investigate.
Does this tool affect my existing installations?
The short answer is: no, Postgre Preferences creates its own configuration files for starting/stopping servers, separate from any existing installations. However, from version 2.1 onwards, Postgre Preferences automatically detects and displays already-running servers that were started/configured elsewhere. Any such 'external' servers can be started and stopped like normal servers (if a configuration file is found). If you click the
'-'button to delete one of the external servers, you will be prompted whether you also want to delete the server's configuration file, or leave it untouched.
Who is Macca Tech, and why did you make this tool?
At the moment, Macca Tech consists of just me, a developer who enjoys creating tools and apps on Mac OS X and iOS. I created this tool partly for fun, and partly because I was using PostgreSQL and found it far too complicated to do something as simple as starting and stopping a database server!
|v2.4.2||8-Feb 2016||Bug-fix release
|v2.4.1||10-Nov 2015||Bug-fix release
|v2.4||30-Aug 2015||Bug-fix release
|v2.3||28-Aug 2015||Enhancement release
|v2.2.1||22-Aug 2015||Bug-fix release
|v2.2||9-Aug 2015||Enhancement release
|v2.1||30-Jul 2015||Enhancement release
|v2.0||22-Jul 2015||Major release
|v1.4.1||22-Jul 2015||Bug-fix release
|v1.4||03-Jul 2015||Bug-fix release
|v1.3||30-Jun 2015||Bug-fix release
|v1.2||30-Jun 2015||Bug-fix release
|v1.1||17-Oct 2014||Bug-fix release
|v1.0.1||10-Mar 2012||Bug-fix release
|v1.0||29-Dec 2011||Initial release|