gem-hunter
Language: Objective-C
Preference Pane for administering PostgreSQL on macOS
A Mac OS X System Preferences pane for controlling the PostgreSQL Database Server.
Features include:
.dmg file by double-clicking it, and then either double-click the contained PostgreSQL.prefPane file, or drag it to System Preferences to install it.
Stop any running PostgreSQL servers:
, select each running server in turn and click the Stop PostgreSQL buttonRemove PostgresPrefs from System Preferences:
in System Preferences, and click RemoveDelete the PostgresPrefs configuration file, if it exists:
rm ~/Library/Preferences/org.postgresql.preferences.servers.plist
sudo rm /Library/Preferences/org.postgresql.preferences.servers.plist
rm ~/Library/LaunchAgents/org.postgresql.preferences.*.plist
sudo rm /Library/LaunchAgents/org.postgresql.preferences.*.plist
sudo rm /Library/LaunchDaemons/org.postgresql.preferences.*.plist
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 initdb command 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 Log button. This will open the default log for the server in Mac OS X's Console log-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 PostgreSQL button. 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!
| Version | Date | Comments |
|---|---|---|
| v2.7 | 28-Mar 2022 | Bugfix release
|
| 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 info@macca.tech
This project is covered by the MIT Licence