Postgres.app is a full-featured PostgreSQL installation packaged as a standard Mac app.It includes everything you need to get started:we’ve even included popular extensions like PostGIS for geo data and plv8 for JavaScript.
Postgres.app has a beautiful user interface and a convenient menu bar item.You never need to touch the command line to use it – but of course we do include all the necessary command line tools and header files for advanced users.
Postgres.app can install minor updates automatically, so you get bugfixes as soon as possible.
Homebrew only really has the postgres formula, and doesn't have any specific formula that only installs the psql tool. So the 'correct way' to get the psql application is indeed to install the postgres formula, and you'll see toward the bottom of the 'caveats' section that it doesn't actually run the database, it just puts the files on your system.
- PostgreSQL management, administration and development GUI for macOSCreated with passion and love. PostgreSQL management, administration and development GUI for macOS. Created with passion and love. Features Purchase.
- Aug 05, 2019 Ok, so there is another great PostgreSQL GUI client software which you may want to consider. It is available for free but there is also the commercial version available. DBeaver is a cross-platform software and it is available for Linux, Windows as well as Mac OS X. It supports various databases such as MariaDB, Oracle, SQL Server and many more.
Installing Postgres.app
- Download ➜ Move to Applications folder ➜ Double ClickIf you don't move Postgres.app to the Applications folder, you will see a warning about an unidentified developer and won't be able to open it.
- Click 'Initialize' to create a new server
- Configure your $PATH to use the included command line tools (optional):
Done! You now have a PostgreSQL server running on your Mac with these default settings:
Host | localhost |
Port | 5432 |
User | your system user name |
Database | same as user |
Password | none |
Connection URL | postgresql://localhost |
To connect with psql, double click a database. To connect directly from the command line, type
psql
. If you’d rather use a graphical client, see below.NOTE: These instructions assume that you’ve never installed PostgreSQL on your Mac before.If you have previously installed PostgreSQL using homebrew, MacPorts, the EnterpriseDB installer, consider removing other PostgreSQL installations first.We also have instructions for upgrading from older versions of Postgres.app.
Graphical Clients
Postgres.app includes
psql
, a versatile command line client for PostgreSQL.But it’s not the only option; there are plenty of great graphical clients available for PostgreSQL.Two popular tools are:pgAdmin 4 is a feature rich open source PostgreSQL client.It has support for almost every feature in PostgreSQL.The only downside is that the cross-plattform UI really doesn’t live up to the expectations of a native Mac app.
Postico on the other hand, is a very modern Mac app.It’s made by the same people that maintain Postgres.app, and we think you’ll like it! We put a lot of effort into making it a joy to use.However, it doesn’t have the extensive feature set of pgAdmin, and it’s a commercial app rather than open source.
Aside from those two options, there are a lot more to choose from! Check the documentation for a list of amazing Mac apps for PostgreSQL.
How to connect
After your PostgreSQL server is up and running, you’ll probably want to connect to it from your application.Here’s how to connect to PostgreSQL from popular programming languages and frameworks:
To connect from PHP, make sure that it supports PostgreSQL. The version included with macOS doesn't support PostgreSQL. We recommend MAMP for an easy way to install a current version of PHP that works.
You can use PDO (object oriented):
Or the pg_connect() functions (procedural):
To connect to a PostgreSQL server with Python, please first install the psycopg2 library:
Django
In your settings.py, add an entry to your DATABASES setting:
Flask
When using the Flask-SQLAlchemy extension you can add to your application code:
SQLAlchemy
To install the pg gem, make sure you have set up your $PATH correctly (see Command-Line Tools), then execute the following command:
Rails
In config/database.yml, use the following settings:
Sinatra
In config.ru or your application code:
ActiveRecord
Install the activerecord gem and require 'active_record', and establish a database connection:
DataMapper
Install and require the datamapper and do_postgres gems, and create a database connection:
Sequel
Install and require the sequel gem, and create a database connection:
- Download and install the PostgreSQL JDBC driver
- Connect to the JDBC URL jdbc:postgresql://localhost
For more information see the official PostgreSQL JDBC documentation.
libpq is the native C client library for connecting to PostgreSQL. It's really easy to use:
Now compile the file with clang and run it:
You can just use the C API in Swift! First include libpq in your bridging header:
Then make sure to link with libpq.
On iOS, you'll need to build libpq yourself.
On macOS you can use the system provided libpq (does not support SSL) or use libpq provided by Postgres.app by adding the following build settings:
Other Linker Flags | -lpq |
---|---|
Header Search Paths | /Applications/Postgres.app/Contents/Versions/latest/include |
Library Search Paths | /Applications/Postgres.app/Contents/Versions/latest/lib |
Now you can use the libpq C library to connect to PostgreSQL:
Support
We have a list of common problems in the troubleshooting section in the documentation.
For general questions concerning PostgreSQL, have a look at the official PostgreSQL documentation.
If you have a question concerning Postgres.app that is not answered by the Postgres.app documentation,you can ask @PostgresApp on Twitter, or open an issue on GitHub.
When reporting bugs, let us know which version of Postgres.app & macOS you are using, and be sure to include detailed error messages, even if your issue seems similar to another one.
License
Postgres.app, PostgreSQL, and its extensions are released under the PostgreSQL License. The released binaries also include OpenSSL (OpenSSL License), PostGIS (GPLv2), and plv8 (3 clause BSD).
Postgres.app is maintained by Jakob Egger and Chris Pastl. It was originally created by Mattt Thompson.
27 product(s) were found in this category.
AspSQLProvider
Description | License | Pricing | Publisher |
---|---|---|---|
AspSQLProvider is a PostgreSQL implementation of the ASP.NET 2.0 Membership, Role, Profile and Session-State Store Provider. | Open source | Nauck IT KG | View |
DBD::Pg
Description | License | Pricing | Publisher |
---|---|---|---|
PostgreSQL database driver for the Perl DBI module | Open source | Greg Sabino Mullane | View |
dbExpress driver for PostgreSQL
Description | License | Pricing | Publisher | |
---|---|---|---|---|
dbExpress Driver for PostgreSQL is a database-independent layer that defines common interface to provide fast access to PostgreSQL from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms. For this server, dbExpress provides a driver as an independent library that implements the common dbExpress interface for processing queries and stored procedures. As>Description | License | Pricing | Publisher | |
dotConnect for PostgreSQL is an enhanced database connectivity solution built over ADO.NET architecture and a development framework with a number of innovative technologies. With state of the art ORM solutions such as Entity Framework and LINQ to SQL, it introduces new approaches for designing applications and boosts productivity of database application development. Key Features
| Commercial | $99.95 | Devart | View |
Excel Add-in for PostgreSQL
Description | License | Pricing | Publisher | |
---|---|---|---|---|
Devart Excel Add-in for PostgreSQL allows you to quickly and easily connect Microsoft Excel to PostgreSQL, load data from PostgreSQL to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to PostgreSQL. It enables you to work with PostgreSQL data like with usual Excel worksheets, easily perform data cleansing and de-duplication, and apply all the Excel's powerful data processing and analysis capabilities to these data. Connect to PostgreSQL Directly from ExcelTo connect Excel to PostgreSQL you just need to specify its host, port, and your credentials. As for security, PostgreSQL Excel Add-in supports secure SSL connections, secure authentication with single sign-on, etc. Use Query Builder or SQL to Import Data You NeedVisual Query Builder allows you to choose a table to import data from, select the columns from this table and related tables, and set filter conditions and data ordering options visually. If you need to select data more precisely, you can use SQL to select data you need. Instantly Refresh Data Whenever You NeedIt's very convenient to always have fresh data from the database right in your workbook. Imagine, you have performed data analysis in your Excel workbook, built some charts for your PostgreSQL data, and you can re-read data from the source and update all this to the current state by just clicking a button on the ribbon whenever you need. Instant Data ValidationExcel Add-in for PostgreSQL instantly validates entered data and highlights errors, such as incorrect dates, duplicate primary key values, etc. Learn more about Excel add-in for PostgreSQL on Devart website. | Commercial | $99.95 | Devart | View |
libpqxx
Description | License | Pricing | Publisher |
---|---|---|---|
libpqxx is the official C++ client API for PostgreSQL, the enterprise-strength open-source database software. | Open source | pqxx.org | View |
LinqConnect
Description | License | Pricing | Publisher | |
---|---|---|---|---|
LinqConnect is a fast, lightweight, and easy to use LINQ to SQL compatible ORM solution, supporting PostgreSQL, SQL Server, Oracle, MySQL and SQLite. It allows using efficient and powerful data access for your .NET Framework, Metro, Silverlight, or Windows Phone applications supporting Code-First, Model-First, Database-First or mixed approaches. | Multiple | Free Edition is Available | Devart | View |
Lua binding for PostgreSQL
Description | License | Pricing | Publisher |
---|---|---|---|
Access your PostgreSQL data from the Lua programming language. luapgsql is a libpq binding for Lua. | Open source | micro systems | View |
Npgsql
Description | License | Pricing | Publisher |
---|---|---|---|
Npgsql is a .Net data provider for PostgreSQL. It allows any program developed for .Net framework to access database server. It is implemented in 100% C# code. Works with PostgreSQL 7.x and 8.x. | Open source | Npgsql Project | View |
ODBC for PostgreSQL
Description | License | Pricing | Publisher | |
---|---|---|---|---|
Devart ODBC Driver for PostgreSQL provides high-performance and feature-rich connectivity solution for ODBC-based applications to access PostgreSQL databases from Windows, Linux, MacOS, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your database applications with PostgreSQL fast, easy and extremely handy. Direct ConnectionDatabase applications based on our solution get an opportunity to establish a connection to PostgreSQL directly. Direct Connection gives your applications an unrivalled advantage — connection to PostgreSQL databases directly via TCP/IP avoiding PostgreSQL Client. IntegrationThe driver is compatible with 3rd-party tools for data analysis, such as Microsoft Excel, and integrates with various IDEs and systems like Visual Studio, etc. Fully Unicode DriverWith our fully Unicode driver, you can retrieve and work with any data from multi-lingual PostgreSQL databases correctly, not depending on whether its charset is Latin, Cyrillic, Hebrew, Chinese, etc., in any environment localization. Bulk UpdatesMoreover, with our driver you can perform bulk updates to PostgreSQL database by combining SQL statements into batches, thus simplifying and speeding up large data modification to PostgreSQL. SecurityWork with PostgreSQL securely using SSL connection options provided in our driver along with the support for SSL protocol. You can also connect to PostgreSQL securely via SSH tunnel. SSH protocol is one of the most reliable protocols for data encryption. Learn more about more ODBC for PostgreSQL features on Devart website. | Commercial | $149.95 | Devart | View |
pgfe
Description | License | Pricing | Publisher |
---|---|---|---|
A modern C++ API to PostgreSQL that simplifies working with PostgreSQL in C++. | Open source | Dmitry Igrishin | View |
pgintcl
Description | License | Pricing | Publisher |
---|---|---|---|
This is a Tcl interface to PostgreSQL, which is itself written entirely in Tcl, and does not rely on libpq. It is highly but not entirely compatible with other Tcl interfaces, although it is slower. | Open source | pgintcl Project | View |
pgtcl
Description | License | Pricing | Publisher |
---|---|---|---|
This is a project to evolve and upgrade libpgtcl, the Tcl client interface to PostgreSQL. Application writers will be able to interface to PostgreSQL from Tcl using this interface. | Open source | pgtcl Project | View |
pgtcl-ng
Description | License | Pricing | Publisher |
---|---|---|---|
PostgreSQL Tcl Interface Next-Generation (pgtcl-ng) is a loadable Tcl/Tk module for accessing PostgreSQL databases. It extends the pre-8.0 libpgtcl from an early Pgtcl release and from the companion project pgintcl. | Open source | pgtcl-ng Project | View |
PostgresClientKit
Description | License | Pricing | Publisher |
---|---|---|---|
PostgresClientKit provides a friendly Swift API for operating against a PostgreSQL database.
| Open source | codewins.com | View |
PostgresDAC
Description | License | Pricing | Publisher | |
---|---|---|---|---|
PostgresDAC is a component suite for direct access to PostgreSQL servers from Borland Delphi and C++ Builder applications | Commercial | $134.95 | Microolap | View |
PostgreSQL Data Access Components
Description | License | Pricing | Publisher | |
---|---|---|---|---|
PostgreSQL Data Access Components (PgDAC) is a library of components that provides native connectivity to PostgreSQL from Delphi and C++Builder including Community Edition, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms. PgDAC is designed to help programmers develop really lightweight, faster and cleaner PostgreSQL database applications without deploying any additional libraries. Native Connectivity to PostgreSQLPgDAC works directly through TCP/IP protocol and does not use the PostgreSQL client library. As data is transferred from socket to storage without additional buffers, the PgDAC performance is maintained on the highest level. Key Features:
Read more about PostgreSQL Data Access Component Editions. | Commercial | 199.95 | Devart | View |
postgresql-kit
Description | License | Pricing | Publisher |
---|---|---|---|
postgresql-kit is a set of frameworks, tools, applications and examples for deploying the PostgreSQL database on Mac OS X and iOS platforms. On the server-side, it provides an embedded server framework which allows you to put a postgresql database right in your Cocoa application. On the client-side, it helps you interact and use all the features of libpq, including converting data seemlessly between Foundation objects and Postgresql data types. Sample applications for the Macintosh and iOS devices is included in the project, which is licensed with the Apache open-source license. | Open source | mutablelogic | View |
PostgreSQL Native OLEDB Provider (PGNP)
Description | License | Pricing | Publisher |
---|---|---|---|
PostgreSQL Native Provider (PGNP) is an OLEDB Provider for PostgreSQL database. The provider features support for Linked Servers, replication, DTS, SSIS and more. It can be used from 32-bit and 64-bit Windows applications both native and .NET. | Commercial | PGNP Team | View |
PostgreSQL-SDBC
Description | License | Pricing | Publisher |
---|---|---|---|
Native PostgreSQL driver for LibreOffice and Apache OpenOffice. It is faster, seamlessly integrated and there is no need to install and setup a JDBC or ODBC driver separately. Compatible with PostgreSQL version 8.4 and later. Not entirely feature-complete, but the basics work. | Open source | The Document Foundation | View |
psql-api
Description | License | Pricing | Publisher |
---|---|---|---|
A PostgreSQL RESTful API for SOA applications. psql-api offers:
Source code is available under MIT license at: | Open source | Q-Bis Consult S.R.L. | View |
psqlJDBC
Description | License | Pricing | Publisher |
---|---|---|---|
The PostgreSQL JDBC driver. It allows Java programs to connect to a PostgreSQL database using standard, database independent Java code. It is a pure Java (Type IV) implementation, so all you need to do is download a jar file and you're on your way. The driver provides are reasonably complete implementation of the JDBC 3 specification in addition to some PostgreSQL specific extensions. | Open source | PostgreSQL Global Development Group | View |
psqlODBC
Description | License | Pricing | Publisher |
---|---|---|---|
psqlODBC is the official PostgreSQL ODBC Driver. | Open source | PostgreSQL Global Development Group | View |
Mac Postgresql Client
psycopg
Description | License | Pricing | Publisher |
---|---|---|---|
Psycopg is the most popular PostgreSQL adapter for the Python programming language. At its core it fully implements the Python DB API 2.0 specifications. Several extensions allow access to many of the features offered by PostgreSQL. | Open source | Psycopg Development Team | View |
slurf
Description | License | Pricing | Publisher |
---|---|---|---|
slurf is an easy to use postgresql frontend.You cannot use it to create tables and such, just to input,update and delete data.It is very good for end user data input (phonebook,invoices etc.). | Open source | Diomedia | View |
SQL Relay
Description | License | Pricing | Publisher |
---|---|---|---|
SQL Relay is a persistent database connection pooling, proxying, throttling, load balancing and query routing/filtering system for PostgreSQL on Linux, Unix and Windows. APIs are provided for C, C++, .NET, ADO.NET, Perl, Perl-DBI, Python, Python-DB, PHP, PHP PDO, Ruby, Java, TCL, Erlang, and node.js, and ODBC. Drop-in replacement libraries are provided for PostgreSQL. The APIs support advanced database operations such as bind variables, multi-row fetches, client-side result set caching and suspended transactions. Command line clients and extensive documentation are also provided. SQL Relay is ideal for speeding up database-driven web-based applications, accessing databases from unsupported platforms, migrating between databases, distributing access to replicated or clustered databases and throttling database access. | Open source | firstworks.com | View |
UniDAC
Macos Client For Postgresql Update
Description | License | Pricing | Publisher | |
---|---|---|---|---|
Universal Data Access Components (UniDAC) is a library of components that provides direct access to multiple databases from Delphi and C++Builder including Community Edition, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms. UniDAC provides access to PostgreSQL, Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, SQLite, Microsoft Access, DB2, DBF, SyBase Advantage Database Server, etc. The tool is compatible with the latest IDE versions and editions including Community Edition: Embarcadero RAD Studio 10.3 Rio, Delphi 10.3 Rio, C++Builder 10.3 Rio, Lazarus (and FPC). It is also compatible with the previous IDE versions since Delphi 6 and C++Builder 6. Key features:
| Commercial | $299.95 | Devart | View |
Macos Client For Postgresql 10
Note: The PostgreSQL Global Development Group do not endorse orrecommend any products listed, and cannot vouch for the quality or reliabilityof any of them.