Where does Homebrew install Postgres executables?

Question

Which directory does Homebrew install Postgres executables in? I've searched just about everywhere.

Chantellechanter

Answer 1

In the bin/ directory managed by Homebrew. Pop open a terminal and run:

$ echo `brew --prefix`/bin

The output will be the directory where Postgres executables are installed.

Gies

yes. and in case anyone is searching for the bin/ dir managed by Homebrew... try /opt/homebrew/bin – Hindward

If you don't find it in /opt/homebrew/bin, try /opt/homebrew/opt – Inapposite

Answer 2

Usually you can find recipes in /usr/local/Cellar . Did you try searching there?

Meacham

Answer 3

For version 14 location is:

/usr/local/Cellar/postgresql@14

Use the complete version to find the executables:

/usr/local/Cellar/postgresql@14/14.8/lib/postgresql@14

Rubdown

Answer 4

You can find Postgres installed via Homebrew at the following location:
(chance that you're looking for postgres config file beside psql, so let me provide it here as well)

Example below for Postgres@16 installed with homebrew (brew install postgresql@16)

For Macbook Apple ARM (M series chip)

/opt/homebrew/Cellar/postgresql@16 <-- Main directory
/opt/homebrew/Cellar/postgresql@16/16.3/bin <-- bin directory (includes psql, pg_dump & stuffs)
/opt/homebrew/var/postgresql@16/ <-- incl Postgres config files (postgresql.conf, pg_hba.conf, etc)

For Macbook Intel

Same as above, instead of path /opt/homebrew/Cellar, it would be /usr/local/Cellar.

/usr/local/Cellar/postgresql@16

Solomon