Each release of Postgres.app comes with the latest stable release of PostgreSQL, as well a few choice extensions. Here’s a rundown of what’s under the hood:
By default, PostgreSQL only allows connections from localhost, and requires no password.
If you want to connect to PostgreSQL from a different computer,
you need to change the
listen_address parameter in the file
which you can find in your data directory (See Connections and Authentication in the PostgreSQL documentation).
Additionally, you need to edit the
pg_hba.conf file to configure which hosts can access the database.
Restart Postgres.app after changing these files.