Skip to main content
0 reactions

How to Install PostgreSQL 19 on macOS

A dark blue card titled Install PostgreSQL 19 on macOS, with a terminal window listing four ticked results: PostgreSQL 19.0, port 5432, psql (19.0) and pgAdmin 4 9.19.
Install PostgreSQL 19 on macOS with the official installer.

PostgreSQL 19 is out. This guide shows how to install PostgreSQL 19 on macOS with the official installer, screen by screen, then connect to it from Terminal with psql.

The installer is made by EDB, and it’s the one postgresql.org lists for macOS. It sets up the database server and its command-line tools, and it offers to install pgAdmin 4, the free graphical tool for PostgreSQL. New to PostgreSQL? Part 1 of the PostgreSQL Tutorial explains what it is.

By the end, you’ll have:

  • PostgreSQL 19 running on your Mac, starting by itself whenever the Mac starts
  • psql, the PostgreSQL command-line tool, working in Terminal
  • pgAdmin 4 in your Applications folder

Every screen and output on this page is real, from PostgreSQL 19.0 on a Mac with macOS 26 and Apple silicon.

Prerequisites

A Mac user account with administrator rights. The installer asks for your Mac password.

Step 1: Download the PostgreSQL 19 Installer

Open the PostgreSQL download page on the EDB website (opens in a new tab). In the 19.0 row, click the download icon under Mac OS X.

The EDB download table with the download button for PostgreSQL 19.0 under Mac OS X highlighted.
Click the download icon under Mac OS X in the 19.0 row.

Your browser downloads postgresql-19.0-1-osx.dmg, about 101 MB, to your Downloads folder.

Step 2: Open the Installer

In Finder, open Downloads and double-click postgresql-19.0-1-osx.dmg. A window opens with the installer app:

The opened PostgreSQL 19.0-1 disk image in Finder, showing the postgresql-19.0-1-osx.app installer icon.
Double-click postgresql-19.0-1-osx.app to start the installer.

Double-click postgresql-19.0-1-osx.app. Because it came from the internet, macOS asks first. Click Open:

A macOS message asking whether to open postgresql-19.0-1-osx.app, an app downloaded from the internet, with Open, Show Disk Image and Cancel buttons.
macOS checks downloaded apps first. Click Open.

macOS then asks for your Mac password, so the installer can install software. Type it and continue. The Setup window opens. Click Next:

The PostgreSQL Setup window showing Welcome to the PostgreSQL Setup Wizard, with the Next button.
The PostgreSQL Setup Wizard opens. Click Next.

Step 3: Keep the Default Folders and Components

The next three screens already hold the right values. On each one, click Next.

Installation Directory is where PostgreSQL’s programs go: /Library/PostgreSQL/19.

The Installation Directory screen of the PostgreSQL installer with the default folder /Library/PostgreSQL/19.
Keep the default folder, /Library/PostgreSQL/19.

Select Components has all three ticked. PostgreSQL Server is the database itself, Command Line Tools include psql, and Stack Builder is an optional tool for installing add-ons later.

The Select Components screen with PostgreSQL Server, Stack Builder and Command Line Tools all ticked.
Keep all three components ticked.

Data Directory is where your databases are stored: /Library/PostgreSQL/19/data.

The Data Directory screen of the PostgreSQL installer with the default folder /Library/PostgreSQL/19/data.
Keep the default data folder, /Library/PostgreSQL/19/data.

Step 4: Choose a Password for the postgres User

PostgreSQL has its own admin user, called postgres. Type a password for it in both boxes, then click Next.

The Password screen asking for a password for the database superuser postgres, with empty Password and Retype password boxes.
Type a password for the postgres user twice, and keep it safe.

Keep this password somewhere safe: you type it each time you connect as postgres. Choose a strong one, even on a Mac only you use. The installer also creates a locked macOS user named postgres, which runs the database server in the background.

Step 5: Keep the Port and the Locale

On Port, keep 5432, the standard PostgreSQL port that apps use to reach the server. Click Next.

The Port screen of the PostgreSQL installer with the default port 5432.
Keep port 5432, the PostgreSQL default.

On Advanced Options, keep the locale at DEFAULT and click Next. The locale sets the language rules for sorting text and formatting dates and numbers.

The Advanced Options screen of the PostgreSQL installer with the Locale set to DEFAULT.
Keep the locale at DEFAULT.

Step 6: Install PostgreSQL 19 and pgAdmin 4

Pre Installation Summary lists your choices. Click Next, then click Next again on Ready to Install to start.

The Pre Installation Summary screen listing the installation and data folders, port 5432, the superuser postgres, the service postgresql-19 and the installation log.
Check the summary, then click Next.

When the server is installed, the installer offers to download and install pgAdmin 4. Click Yes. It downloads the latest version, 9.19 when I installed it, and adds pgAdmin 4 to your Applications folder.

A message from the PostgreSQL installer asking whether to automatically download and install the latest version 9.19 of pgAdmin 4, with No and Yes buttons.
Click Yes to download and install pgAdmin 4 as well.

When the last screen appears, untick Launch Stack Builder at exit and click Finish. You don’t need any add-ons to get started.

The last screen of the PostgreSQL installer saying setup has finished installing PostgreSQL, with Launch Stack Builder at exit unticked and the Finish button.
Untick Stack Builder, then click Finish.

PostgreSQL 19 is now installed and running. The installer also added a PostgreSQL 19 folder to Applications, with shortcuts such as SQL Shell (psql) and Stack Builder.

Step 7: Add PostgreSQL to Your PATH

Terminal finds programs by searching the folders listed in a setting called PATH. psql is in /Library/PostgreSQL/19/bin, which isn’t on that list yet. Open Terminal (press ⌘ Space, type Terminal and press Return), then run:

TerminalBash
echo 'export PATH="/Library/PostgreSQL/19/bin:$PATH"' >> ~/.zshrc

This adds one line to ~/.zshrc, the settings file that zsh, the Mac’s standard shell, reads each time Terminal opens a window. Press ⌘N to open a new Terminal window, which reads the new line.

Step 8: Connect to PostgreSQL with psql

In the new window, connect as the postgres user:

TerminalBash
psql -U postgres

-U postgres tells psql which user to connect as. Type the password from Step 4 and press Return. Nothing appears while you type, which is normal.

OutputPlain text
Password for user postgres:
psql (19.0)
Type "help" for help.

postgres=#

You’re connected. postgres=# is the psql prompt: psql is waiting for a command. Ask the server which version it runs:

postgres=#SQL
SHOW server_version;
OutputPlain text
 server_version
----------------
 19.0
(1 row)

The server answers 19.0. Type \q and press Return to leave psql:

postgres=#Plain text
\q

Clean Up

There’s nothing to clean up: this guide only installs PostgreSQL, and the server keeps running so it’s ready when you need it. To remove PostgreSQL 19 later, follow How to Completely Uninstall PostgreSQL from macOS (EDB Installer).

Common Mistakes

MistakeWhat you seeFix
Running psql in a Terminal window that was open before Step 7zsh: command not found: psqlPress ⌘N for a new window and run it again.
Typing your Mac password instead of the postgres passwordpsql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: password authentication failed for user "postgres"Type the password you chose in Step 4.

FAQ

Does PostgreSQL start by itself when my Mac starts?

Yes. The installer sets PostgreSQL up as a background service, postgresql-19, that starts whenever the Mac starts. You don’t need to start it yourself.

Where does PostgreSQL keep my databases?

In the data folder from Step 3, /Library/PostgreSQL/19/data. Leave its files to PostgreSQL: change your data with SQL, never by editing those files.

Is PostgreSQL free?

Yes, for personal and commercial use. Is PostgreSQL Free for Commercial Use? explains its licence.

Do I need pgAdmin?

No. psql can do everything, and this series uses both. pgAdmin shows your databases in windows and lists instead of text, which many beginners find easier.

Conclusion

PostgreSQL 19 is installed on your Mac, starts by itself and answers in Terminal. Next in the series: Part 2: Connect with psql and Run Your First Commands (coming soon). The PostgreSQL Tutorial for Beginners page lists every part and setup guide.

Additional Resources

Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission.

0 comments