Preference Pane for administering PostgreSQL on macOS
A Mac OS X System Preferences pane for controlling the PostgreSQL Database Server.
.dmgfile by double-clicking it, and then either double-click the contained
PostgreSQL.prefPanefile, or drag it to System Preferences to install it.
Stop any running PostgreSQL servers:
Remove PostgresPrefs from System Preferences:
Delete the PostgresPrefs configuration file, if it exists:
rm ~/Library/Preferences/org.postgresql.preferences.servers.plist sudo rm /Library/Preferences/org.postgresql.preferences.servers.plist
Delete any configuration files for starting/stopping individual PostgreSQL servers, if they exist:
rm ~/Library/LaunchAgents/org.postgresql.preferences.*.plist sudo rm /Library/LaunchAgents/org.postgresql.preferences.*.plist sudo rm /Library/LaunchDaemons/org.postgresql.preferences.*.plist
Delete the log directories containing log files for your PostgreSQL servers, if they exist:
rm -rf ~/Library/Logs/PostgreSQL sudo rm -rf /Library/Logs/PostgreSQL
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 macOS 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.6||28-Feb 2020||Enhancement release
|v2.5||12-Feb 2020||Bugfix release
|v2.4.3||20-Jan 2020||Bugfix release
|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|
Please email any feedback to [email protected]
This project is covered by the MIT Licence