PostgreSQL for Mac is a collection of graphical tools for using and managing PostgreSQL servers, as well as the server itself installable on any Mac running OS X version 10.5.x.
Also included as part of the package is the PGSQLKit framework, an open source framework for developers to leverage the power of PostgreSQL in their own applications.
After many years of development, PostgreSQL has become feature-complete in many areas. This release shows a targeted approach to adding features (e.g., authentication, monitoring, space reuse), and adds capabilities defined in the
What's New
Version 9.0.1:
Everything is now in one installer. 9.0.1 is the default, but you can select the 8.4.5 version from the custom installation option.
Contrib is now builit in
The installer now goes to the /Library/PostgreSQL folder instead of /Library/PostgreSQL8. If you would like, you can move your existing folder to that location for an upgrade, or you can leave them in place side by side. Symlinks will work too.
We have dropped support for 10.4. As we migrate to use the newer features of the Cocoa platform, 10.4 is becoming increasingly difficult to keep in sync. With that in mind, we have dropped support for 10.4. We can support it if needed, but it is time consuming.
pgAdmin is now installed as part of the installation
The Automator Query actions are now installed by default.
JDBC4 is now in the installer, but it is an optional installation.
Symlinks are now correct with regards to doc and man.
pg_set_version.sh will no longer create bogus doc and man folder links.
Version 9.0.1:
Everything is now in one installer. 9.0.1 is the default, but you can select the 8.4.5 version from the custom installation option.
Contrib is now builit in
The installer now goes to the /Library/PostgreSQL folder instead of /Library/PostgreSQL8. If you would like, you can move your existing folder to that location for an upgrade, or you can leave them in place more...
Both are true, this is not the official distribution from PostgreSQL, it does predate the one that is linked from PostgreSQL.org. The one provided on PostgreSQL.org is built by David Page at EnterpriseDB, and is also quite good. No confusion was intended as to the authenticity of this build. There is also a third binary distribution of PostgreSQL for the Mac published by Marc Liyange. Each have different targets.
As for download speed, the SourceForge clusters are significantly faster than the druware links. Something about money and bandwidth. SourceForge has large sums of cash behind it. Druware, not so much. More like starving artists.
2) query tool installed by default (during the server install) is BAD - it seems to have been compiled as a PPC only, and not as a universal binary, so it won't run on my Intel machine.
3) documentation provided needs urgent updating, including: instructions for manual uninstall (in case the uninstaller goes missing again, or user is unable to run it), instructions for drag-install of client tools, and a basic troubleshooting guide (telling users what to do if the server does not seem to launch)
Your efforts to bring PostgreSQL to the Mac are certainly appreciated. Please, keep up the good work.
On my system, Query Tool for Postgres, and Create User both crash immediately. The other three tools (Create & Backup Database and Service Manager) seem to work ok.
Crash log follows...
11/7/07 3:25:53 PM com.apple.launchd[211] ([0x0-0x44044].com.druware.postgresql.CreateUser[2005]) Exited abnormally: Trace/BPT trap
11/7/07 3:29:10 PM [0x0-0x47047].com.druware.postgres.QueryTool[2019] dyld: Library not loaded: @executable_path/../Frameworks/pgCocoaDB.framework/Versions/A/pgCocoaDB
11/7/07 3:29:10 PM [0x0-0x47047].com.druware.postgres.QueryTool[2019] Referenced from: /Applications/PostgreSQL/Query Tool for Postgres.app/Contents/MacOS/Query Tool for Postgres
11/7/07 3:29:10 PM [0x0-0x47047].com.druware.postgres.QueryTool[2019] Reason: image not found
11/7/07 3:29:10 PM com.apple.launchd[211] ([0x0-0x47047].com.druware.postgres.QueryTool[2019]) Exited abnormally: Trace/BPT trap
11/7/07 3:29:29 PM [0x0-0x4a04a].com.druware.postgresql.CreateUser[2026] dyld: Library not loaded: @executable_path/../Frameworks/pgCocoaDB.framework/Versions/A/pgCocoaDB
11/7/07 3:29:29 PM [0x0-0x4a04a].com.druware.postgresql.CreateUser[2026] Referenced from: /Applications/PostgreSQL/Create User.app/Contents/MacOS/Create User
11/7/07 3:29:29 PM [0x0-0x4a04a].com.druware.postgresql.CreateUser[2026] Reason: image not found
Both downloads on both download locations have been updated to fix this (boneheaded) issue. The problem was twofold. The build machine had an errant copy of the binaries that included a bad build, and the final copy phase had an issue on several of the GUI tools. Both problems have been resolved. Sorry for the confusion.
What part is not installed as Universal? I'm trying to isolate which part, the server and command line tools, as well as the GUI tools appear to be Universal here. There *is* a problem with a couple of the tools that will be fixed today where the connection framework failed the copy which didn't show up o nteh QA machines as they also have the /Library/Frameworks/ vesion of the frameworks installed (oops).
Ah, problem found and will be fixed in shortly. In the transition from Xcode to Xcodeproj the PPC build setting got lost. I has now been fixed in SVN and will be rebuilt and updated in the package this afternoon.
Please login or create a new MacUpdate Member account to use this feature
Watch Lists are available to MacUpdate Desktop Members Upgrade Now
Download and auto-install
using MacUpdate Desktop. Save
time moving folders and cleaning-up.
PostgreSQL for Mac is a collection of graphical tools for using and managing PostgreSQL servers, as well as the server itself installable on any Mac running OS X version 10.5.x.
Also included as part of the package is the PGSQLKit framework, an open source framework for developers to leverage the power of PostgreSQL in their own applications.
After many years of development, PostgreSQL has become feature-complete in many areas. This release shows a targeted approach to adding features (e.g., authentication, monitoring, space reuse), and adds capabilities defined in the later SQL standards.
+4
+3
+480
2. If you're going to download or link to this, it's better to do it from their SourceForge page because their web site isn't as speedy:
http://sourceforge.net/projects/pgsqlformac/
+2
As for download speed, the SourceForge clusters are significantly faster than the druware links. Something about money and bandwidth. SourceForge has large sums of cash behind it. Druware, not so much. More like starving artists.
+480
+1
Cascalheira reviewed on 14 Mar 2010
Great job
+2
+21
1) uninstaller is missing
2) query tool installed by default (during the server install) is BAD - it seems to have been compiled as a PPC only, and not as a universal binary, so it won't run on my Intel machine.
3) documentation provided needs urgent updating, including: instructions for manual uninstall (in case the uninstaller goes missing again, or user is unable to run it), instructions for drag-install of client tools, and a basic troubleshooting guide (telling users what to do if the server does not seem to launch)
Your efforts to bring PostgreSQL to the Mac are certainly appreciated. Please, keep up the good work.
+1
+3
-2
-2
Crash log follows...
11/7/07 3:25:53 PM com.apple.launchd[211] ([0x0-0x44044].com.druware.postgresql.CreateUser[2005]) Exited abnormally: Trace/BPT trap
11/7/07 3:29:10 PM [0x0-0x47047].com.druware.postgres.QueryTool[2019] dyld: Library not loaded: @executable_path/../Frameworks/pgCocoaDB.framework/Versions/A/pgCocoaDB
11/7/07 3:29:10 PM [0x0-0x47047].com.druware.postgres.QueryTool[2019] Referenced from: /Applications/PostgreSQL/Query Tool for Postgres.app/Contents/MacOS/Query Tool for Postgres
11/7/07 3:29:10 PM [0x0-0x47047].com.druware.postgres.QueryTool[2019] Reason: image not found
11/7/07 3:29:10 PM com.apple.launchd[211] ([0x0-0x47047].com.druware.postgres.QueryTool[2019]) Exited abnormally: Trace/BPT trap
11/7/07 3:29:29 PM [0x0-0x4a04a].com.druware.postgresql.CreateUser[2026] dyld: Library not loaded: @executable_path/../Frameworks/pgCocoaDB.framework/Versions/A/pgCocoaDB
11/7/07 3:29:29 PM [0x0-0x4a04a].com.druware.postgresql.CreateUser[2026] Referenced from: /Applications/PostgreSQL/Create User.app/Contents/MacOS/Create User
11/7/07 3:29:29 PM [0x0-0x4a04a].com.druware.postgresql.CreateUser[2026] Reason: image not found
+2
+322
+2
+2