Top Articles
I have recently started using PostgreSQL with my rails app.
I was looking for a SQL GUI to the PostgreSQL database (for Mac).
Anything better than pgadmin3?
Postico makes PostgreSQL approachable. PostgreSQL is an absurdly powerful database, but there's no reason why using it should require an advanced degree in relational theory. Postico provides an easy to use interface, making Postgres more accessible for newcomers and specialists alike.
Max VernonThis question appears to be off-topic. The users who voted to close gave this specific reason:
Check the wiki page, many different tools available.
Frank HeikensFrank HeikensI'm currently developing a Mac client for PostgreSQL named PG Commander. My goal is to make the best designed PostgreSQL client for the Mac -- it's not as full featured as pgAdmin, but it's a lot easier to use.
Check out JackDB, it's a database client entirely in your web browser.
There's no software to install locally so you can use it on Mac OS X, Linux, and Windows and it works on all major modern browsers (eg. Chrome, Firefox, IE, Safari, and Opera). It supports connecting to PostgreSQL, as well as MySQL, Oracle, and SQL Server databases.
Migration of Sites and Options - Sites and Global Options settings in previous installation will be automatically migrated during upgrade. A sample TappIn connection will be included by default. Go global mobile client. CuteFTP Mac Professional is the most advanced Mac FTP client available. WebDAV Support - CuteFTP v9 includes support for the WebDAV protocol in order to provide additional possible endpoints for CuteFTP. Support for UNICODE Character Set - CuteFTP v9 supports the UTF-8 character set throughout the product.
Full disclosure: I'm the founder of JackDB.
I've been experimenting DbSchema (www.dbschema.com). I've been using the trial version and I'm pretty close to purchasing a license. While there are lots of tools for editing and submitting SQL requests (I like DbVisualizer) I like features in DbSchema. First, it has an interesting graphical database schema design tool for creating schemas and then applying them to a database. Second, it has a graphical way of querying tables. The 'graphical' part is selecting the join criteria, to use multiple tables. While I'm comfortable with SQL I'm also interested in a tool that will let others search tables without resorting to SQL.
I'm using it to manage a Postgres DB. Although I'm designing my schema from scratch DbSchema does 'import' schemas from existing databases.
I should add that I'm using DbSchema in Mavericks with Postgres running on the same laptop. DbSchema doesn't act like a native app. It's probably a Java client app--which is not a problem for me.
PostgreSQL is the default database on macOS Server as of OS X Server version 10.7.macOS without the macOS Server add-on installed includes only the PostgreSQLlibpq shared library.
macOS Server 10.12 ships with PostgreSQL 9.4. Minor updates are providedby Apple, but not necessarily right after a new PostgreSQL minor release.
There are several other installers available for PostgreSQL on macOS,which is the recommended way to install.
Download the installercertified by EnterpriseDB for all supported PostgreSQL versions.
This installer includes the PostgreSQL server, pgAdmin; a graphical tool for managing and developingyour databases, and StackBuilder; a package manager that can be used to download and installadditional PostgreSQL tools and drivers. Stackbuilder includes management,integration, migration, replication, geospatial, connectors and other tools.
This installer can run in graphical, command line, or silent install modes.
The installer is designed to be a straightforward, fast way to get up and running withPostgreSQL on macOS.
Advanced users can also download azip archiveof the binaries, without the installer.This download is intended for users who wish to include PostgreSQL as part of another application installer.
The installers are tested by EnterpriseDB on the following platforms. They will generally work on newer versions of macOS as well:
PostgreSQL Version | 64-bit macOS Platforms |
---|---|
11 | 10.12 - 10.14 |
10 | 10.10 - 10.12 |
9.6 | 10.10 - 10.12 |
9.5 | 10.8 - 10.10 |
9.4 | 10.6 - 10.9 |
Postgres.app is a simple, native macOS app that runs in the menubar without the need of an installer. Open the app, and you have a PostgreSQL serverready and awaiting new connections. Close the app, and the server shuts down.
PostgreSQL packages are available for macOS from theFink Project.Please see the Fink documentation for information on how to install packages.
A list ofPostgreSQL packagescan be found using the package search tool on the Fink website.
PostgreSQL packages are also available for macOS from theMacPorts Project. Please see theMacPorts documentation for information on how to install ports.
A list ofPostgreSQL packagescan be found using the portfiles search tool on the MacPorts website.
It can be used with a torrent program, for example, so that the program is only active when the VPN is connected. Torrent client for mac.
PostgreSQL can also be installed on macOSusing Homebrew. Please see the Homebrewdocumentation for information on how to install packages.
A listof PostgreSQLpackages can be found using the Braumeister search tool.