- Postico 1 3 – A Modern Postgresql Client Setting Permissions
- Postico 1 3 – A Modern Postgresql Client Settings
- Postico 1 3 – A Modern Postgresql Client Setting Example
You are looking at the documentation for Postico v1.3.5 — would you like to go to the latest version instead?
But the best part of Postico is how well it works. Postico is made on a Mac for a Mac. It works great with all your other Mac apps. Use all the usual keyboard shortcuts. Postico gets the basic things like copy/paste just right, and also supports more advanced features like services for text editing. What’s New in Version 1.0.10.
Postico 1.3.2 – A modern PostgreSQL client. February 3, 2018 Postico provides an easy to use interface, making Postgres more accessible for newcomers and specialists alike. Postico 1.0.10 – A modern PostgreSQL client. October 14, 2016. Added a hidden setting to disable restoring the text in the SQL Query View #256 defaults write at.eggerapps.Postico DontRestoreQueryViewText 1; Postico now remembers the size and position of the favorites window. Postico is a modern Postgres client for OSX, built by the same developer who built Postgres.app (mentioned above). It is free, but you can buy a license to unlock additional power features. This is the GUI that I use to manage Postgres because it is built specifically for Mac and has a beautiful, very easy to use (but powerful) UI. Filter rows that contain a search term, or set up advanced filters with multiple conditions. Quickly view rows from related tables, and save time by editing multiple rows at once. For analytics workloads, Postico has a powerful query editor with syntax highlighting and many advanced text editing features.
Postgres.app
To connect to Postgres.app, you can leave all fields blank.
- Host: localhost
- Port: 5432
- User: your user name
- Password: blank
- Database: your user name
See also: Installing Postgres.app
EnterpriseDB
To connect to a PostgreSQL server installed with the graphical installer from EnterpriseDB, click the “New Favorite” button and provide the following parameters:
Postico 1 3 – A Modern Postgresql Client Setting Permissions
- Host: localhost
- Port: 5432 (can be changed during installation)
- User: postgres
- Password: selected during installation
- Database: postgres
MacPorts
To connect to a PostgreSQL server installed with MacPorts, use the following parameters:
- Host: localhost
- Port: 5432
- User: postgres
- Password: blank
- Database: postgres
Firewalls & Internet Filters
Some protection products interfere with TCP connections. For example, a product named X3 Protect has been known to block connection attempts to local PostgreSQL servers. If you are having trouble connecting to a local PostgreSQL server, try disabling your firewall, or add an exception for port 5432.
“Resolving localhost failed”
This error message usually appears when there is a problem with the /etc/hosts file. Make sure there is an entry for localhost. As a workaround, you can also type “127.0.0.1” into the host field instead of “localhost”.
TCP vs. Socket connections
Postico 1 3 – A Modern Postgresql Client Settings
There are two ways to connect to a local PostgreSQL server:
- Using a TCP connection (localhost, 127.0.0.1, ::1)
- Using a Unix socket connection (/tmp/.s.PGSQL)
Postico always uses TCP connections. Postico can't use socket connections because sandboxed apps are not allowed to access unix sockets outside their sandbox.
Postico 1 3 – A Modern Postgresql Client Setting Example
By default, PostgreSQL is always configured to listen for TCP connections on localhost, so that should not be a problem unless you explicitly disabled TCP connections.