If you are on a Mac, then Homebrew is the way to install stuff. It seems that version 8 is no longer the most recent, so it isnt available using the default brew cask install java. Instead I managed by doing the following: brew install homebrew/cask-versions/. This no longer works. I have Homebrew 2.7.1 running on Mac OS Catalina 10.15.4 Using brew tap followed by brew install -cask from another comment apparently worked fine. – timurb Dec 29 '20 at 14:56.
In this tutorial we will learn to install PostgreSQL database on Mac using Homebrew.
Prerequisite
It is assumed that you have Homebrew installed on your Mac.
If you don't have Homebrew installed on your Mac then open Terminal and run the following command.
You can visit Homebrew official website https://brew.sh to learn more about it.
Once you have Homebrew (a.k.a. brew) installed on your machine you can run the following command in the Terminal to check the version.
To update run the following command.
Alright, time to install PostgreSQL on Mac.
Install PostgreSQL using Homebrew
In Terminal run the following command to install PostgreSQL on Mac using Homebrew.
We can check the version of PostgreSQL using the psql command.
Start PostgreSQL
To start PostgreSQL run the following command in the Terminal.
We will get a similar output shown below.
Stop PostgreSQL
To stop PostgreSQL run the following command in the Terminal.
We will get a similar output.
Restart PostgreSQL
To restart PostgreSQL run the following command in the Terminal.
We will get a similar output as shown below.
Login to PostgreSQL database
By default we will get a database by the name postgres. So, to connect to it we will run the following command.
We will see the following output.
List all the users
To list all the users we use the du command.
List all the databases
To list all the databases run the l command.
Create a database
To create a database run the following command. In the given example mydb is the name of the database.
Connect to a database
To connect to a database use the c command.
List all the tables inside a database
To list all the tables inside a database we run the d command.
Note! If there is no table then we will get a prompt stating no relations found.
Let us go ahead and create a simple users table inside the mydb database and try the above command again.
Mac Brew Command Not Found
Create table
In the following example we are creating a simple users table.
Now if we list the tables using the d command we will get the table.
How to exit from psql?
To exit or quit from psql type the q command.
Alright, this brings us to the end of this tutorial. Hope you found it useful. Please share this tutorial if it was helpful. See you in the next tutorial. Have fun developing :-)
Is there a glossary of terms around?
All your terminology needs can be found here.
How do I update my local packages?
First update the formulae and Homebrew itself:
Update Brew In Mac
You can now find out what is outdated with:
Upgrade everything with:
Or upgrade a specific formula with:
How do I stop certain formulae from being updated?
To stop something from being updated/upgraded:
To allow that formulae to update again:
Note that pinned, outdated formulae that another formula depends on need to be upgraded when required, as we do not allow formulae to be built against outdated versions. If this is not desired, you can instead brew extract to maintain your own copy of the formula in a tap.
How do I uninstall Homebrew?
To uninstall Homebrew, run the uninstall script from the Homebrew/install repository.
How can I keep old versions of a formula when upgrading?
Homebrew automatically uninstalls old versions of a formula after that formula is upgraded with brew upgrade, and periodically performs additional cleanup every 30 days.
To disable automatic brew cleanup:
When automatic brew cleanup is disabled, if you uninstall a formula, it will only remove the latest version you have installed. It will not remove all versions of the formula that you may have installed in the past. Homebrew will continue to attempt to install the newest version it knows about when you run brew upgrade. This can be surprising.
In this case, to remove a formula entirely, you may run brew uninstall --force . Be careful as this is a destructive operation.
Why does brew upgrade also upgrade a bunch of other stuff?
Homebrew doesn't support arbitrary mixing and matching of formula versions, so everything a formula depends on, and everything that depends on it in turn, needs to be upgraded to the latest version as that's the only combination of formulae we test. As a consequence any given upgrade or install command can upgrade many other (seemingly unrelated) formulae, if something important like python or openssl also needed an upgrade.
Where does stuff get downloaded?
Which is usually: ~/Library/Caches/Homebrew
My Mac .apps don't find /usr/local/bin utilities!
GUI apps on macOS don't have /usr/local/bin in their PATH by default. If you're on Mountain Lion or later, you can fix this by running sudo launchctl config user path '/usr/local/bin:$PATH' and then rebooting, as documented in man launchctl. Note that this sets the launchctl PATH for all users. For earlier versions of macOS, see this page.
How do I contribute to Homebrew?
Read our contribution guidelines.
Why do you compile everything?
Homebrew provides pre-compiled versions for many formulae. Thesepre-compiled versions are referred to as bottles and are availableat https://github.com/Homebrew/homebrew-core/packages.
If available, bottled binaries will be used by default except under thefollowing conditions:
- Options were passed to the install command, i.e.
brew installwill use a bottled version of the formula, butbrew install --enable-barwill trigger a source build. - The
--build-from-sourceoption is invoked. - The machine is not running a supported version of macOS as allbottled builds are generated only for supported macOS versions.
- Homebrew is installed to a prefix other than the standard
/usr/local(although some bottles support this).
We aim to bottle everything.
How do I get a formula from someone else's branch?
Why should I install Homebrew in the default location?
Homebrew's pre-built binary packages (known as bottles) of many packages can only be used if you install in the default installation prefix, otherwise they have to be built from source. Building from source takes a long time, is prone to fail, and is not supported. Do yourself a favour and install to the default prefix so that you can use our pre-built binary packages. The default prefix is /usr/local for macOS on Intel, /opt/homebrew for macOS on ARM, and /home/linuxbrew/.linuxbrew for Linux. Pick another prefix at your peril!
Why does Homebrew prefer I install to /usr/local?
- It's easier
/usr/local/binis already in yourPATH. - It's easier
Tons of build scripts break if their dependenciesaren't in either/usror/usr/local. Wefix this for Homebrew formulae (although we don't always test forit), but you'll find that many RubyGems and Python setup scriptsbreak which is something outside our control. - It's safe
Apple has assigned this directory for non-system utilities. This meansthere are no files in/usr/localby default, so thereis no need to worry about messing up existing or system tools.
If you plan to install gems that depend on formulae then save yourself a bunch of hassle and install to /usr/local!
It is not always straightforward to tell gem to look in non-standard directories for headers and libraries. If you choose /usr/local, many things will 'just work'.
Why is the default installation prefix /home/linuxbrew/.linuxbrew on Linux?
The prefix /home/linuxbrew/.linuxbrew was chosen so that users without admin access can ask an admin to create a linuxbrew role account and still benefit from precompiled binaries. If you do not yourself have admin privileges, consider asking your admin staff to create a linuxbrew role account for you with home directory /home/linuxbrew.
Why does Homebrew say sudo is bad?
tl;dr Sudo is dangerous, and you installed TextMate.app without sudoanyway.
Homebrew refuses to work using sudo.
You should only ever sudo a tool you trust. Of course, you can trust Homebrew😉 But do you trust the multi-megabyte Makefile that Homebrew runs? Developersoften understand C++ far better than they understand make syntax. It's too higha risk to sudo such stuff. It could modify (or upload) any files on yoursystem. And indeed, we've seen some build scripts try to modify /usr even whenthe prefix was specified as something else entirely.
We use the macOS sandbox to stop this but this doesn't work when run as the root user (which also has read and write access to almost everything on the system).
Did you chown root /Applications/TextMate.app? Probablynot. So is it that important to chown root wget?
If you need to run Homebrew in a multi-user environment, considercreating a separate user account especially for use of Homebrew.
Why isn't a particular command documented?
If it's not in man brew, it's probably an external command. These are documented here.
Why haven't you merged my pull request?
If it's been a while, bump it with a 'bump' comment. Sometimes we miss requests and there are plenty of them. Maybe we were thinking on something. It will encourage consideration. In the meantime if you could rebase the pull request so that it can be cherry-picked more easily we will love you for a long time.
Can I edit formulae myself?
Yes! It's easy! Just brew edit . You don't have to submit modifications back to homebrew/core, just edit the formula as you personally need it and brew install . As a bonus brew update will merge your changes with upstream so you can still keep the formula up-to-date with your personal modifications!
Can I make new formulae?
Yes! It's easy! Just brew create URL. Homebrew will then open the formula inEDITOR so you can edit it, but it probably already installs; try it: brewinstall . If you encounter any issues, run the command with the--debug switch like so: brew install --debug , which drops youinto a debugging shell.
If you want your new formula to be part of homebrew/core or wantto learn more about writing formulae, then please read the Formula Cookbook.
Can I install my own stuff to /usr/local?
Yes, brew is designed to not get in your way so you can use it how youlike.
Install your own stuff, but be aware that if you install commonlibraries like libexpat yourself, it may cause trouble when trying tobuild certain Homebrew formula. As a result brew doctor will warn youabout this.
Thus it's probably better to install your own stuff to the Cellar andthen brew link it. Like so:
Why was a formula deleted or disabled?
Use brew log to find out! Likely because it had unresolved issues and/or our analytics identified it was not widely used.
For disabled and deprecated formulae, running brew info will also provide an explanation.
Homebrew is a poor name, it's too generic, why was it chosen?
Homebrew's creator @mxcl was too concerned with the beer theme and didn't consider that the project may actually prove popular. By the time Max realised that it was popular, it was too late. However, today, the first Google hit for 'homebrew' is not beer related 😉
What does 'keg-only' mean?
It means the formula is installed only into the Cellar and is not linked into /usr/local. This means most tools will not find it. You can see why a formula was installed as keg-only, and instructions to include it in your PATH, by running brew info .
You can still link in the formula if you need to with brew link , though this can cause unexpected behaviour if you are shadowing macOS software.
How can I specify different configure arguments for a formula?
brew edit and edit the formula. Citrix receiver for windows 7. Currently there is noother way to do this.
The app can't be opened because it is from an unidentified developer
Chances are that certain apps will give you a popup message like this:
This is a security feature from Apple. The single most important thing to know is that you can allow individual apps to be exempt from that feature. This allows the app to run while the rest of the system remains under protection.
Always leave system-wide protection enabled, and disable it only for specific apps as needed.
If you are sure you want to trust the app, you can disable protection for that app by right-clicking its icon and choosing Open:
Finally, click the Open button if you want macOS to permanently allow the app to run on this Mac. Don't do this unless you're sure you trust the app.
Alternatively, you may provide the --no-quarantine flag at install time to not add this feature to a specific app.
Why some apps aren't included in upgrade
After running brew upgrade, you may notice some casks you think should be upgrading, aren't.
As you're likely aware, a lot of macOS software can upgrade itself:
That could cause conflicts when used in tandem with Homebrew Cask's upgrade mechanism.
If you upgrade software through it's built-in mechanism, that happens without Homebrew Cask's knowledge so both versions get out of sync. If you then upgraded through Homebrew Cask and we have a lower version on the software on record, you'd get a downgrade.
There are a few ideas to fix this problem:
- Try to prevent the software's automated updates. That won't be a universal solution and may cause it to break. Most software on Homebrew Cask is closed-source, so we'd be guessing. This is also why pinning casks to a version isn't available.
- Try to extract the installed software's version and compare it to the cask, deciding what to do at that time. That's a complicated solution that breaks other parts of our methodology, such as using versions to interpolate in
urls (a definite win for maintainability). That solution also isn't universal, as many software developers are inconsistent in their versioning schemes (and app bundles are meant to have two version strings) and it doesn't work for all types of software we support.
So we let software be. Installing it with Homebrew Cask should make it behave the same as if you had installed it manually. But we also want to support software that does not auto-upgrade, so we add auto_updates true to casks of software that can do it, which excludes them from brew upgrade.
Casks which use version :latest are also excluded, because we have no way to track the version they're in. It helps to ask the developers of such software to provide versioned releases (i.e. have the version in the path of the download url).
If you still want to force software to be upgraded via Homebrew Cask, you can:
We aim to bottle everything.
How do I get a formula from someone else's branch?
Why should I install Homebrew in the default location?
Homebrew's pre-built binary packages (known as bottles) of many packages can only be used if you install in the default installation prefix, otherwise they have to be built from source. Building from source takes a long time, is prone to fail, and is not supported. Do yourself a favour and install to the default prefix so that you can use our pre-built binary packages. The default prefix is /usr/local for macOS on Intel, /opt/homebrew for macOS on ARM, and /home/linuxbrew/.linuxbrew for Linux. Pick another prefix at your peril!
Why does Homebrew prefer I install to /usr/local?
- It's easier
/usr/local/binis already in yourPATH. - It's easier
Tons of build scripts break if their dependenciesaren't in either/usror/usr/local. Wefix this for Homebrew formulae (although we don't always test forit), but you'll find that many RubyGems and Python setup scriptsbreak which is something outside our control. - It's safe
Apple has assigned this directory for non-system utilities. This meansthere are no files in/usr/localby default, so thereis no need to worry about messing up existing or system tools.
If you plan to install gems that depend on formulae then save yourself a bunch of hassle and install to /usr/local!
It is not always straightforward to tell gem to look in non-standard directories for headers and libraries. If you choose /usr/local, many things will 'just work'.
Why is the default installation prefix /home/linuxbrew/.linuxbrew on Linux?
The prefix /home/linuxbrew/.linuxbrew was chosen so that users without admin access can ask an admin to create a linuxbrew role account and still benefit from precompiled binaries. If you do not yourself have admin privileges, consider asking your admin staff to create a linuxbrew role account for you with home directory /home/linuxbrew.
Why does Homebrew say sudo is bad?
tl;dr Sudo is dangerous, and you installed TextMate.app without sudoanyway.
Homebrew refuses to work using sudo.
You should only ever sudo a tool you trust. Of course, you can trust Homebrew😉 But do you trust the multi-megabyte Makefile that Homebrew runs? Developersoften understand C++ far better than they understand make syntax. It's too higha risk to sudo such stuff. It could modify (or upload) any files on yoursystem. And indeed, we've seen some build scripts try to modify /usr even whenthe prefix was specified as something else entirely.
We use the macOS sandbox to stop this but this doesn't work when run as the root user (which also has read and write access to almost everything on the system).
Did you chown root /Applications/TextMate.app? Probablynot. So is it that important to chown root wget?
If you need to run Homebrew in a multi-user environment, considercreating a separate user account especially for use of Homebrew.
Why isn't a particular command documented?
If it's not in man brew, it's probably an external command. These are documented here.
Why haven't you merged my pull request?
If it's been a while, bump it with a 'bump' comment. Sometimes we miss requests and there are plenty of them. Maybe we were thinking on something. It will encourage consideration. In the meantime if you could rebase the pull request so that it can be cherry-picked more easily we will love you for a long time.
Can I edit formulae myself?
Yes! It's easy! Just brew edit . You don't have to submit modifications back to homebrew/core, just edit the formula as you personally need it and brew install . As a bonus brew update will merge your changes with upstream so you can still keep the formula up-to-date with your personal modifications!
Can I make new formulae?
Yes! It's easy! Just brew create URL. Homebrew will then open the formula inEDITOR so you can edit it, but it probably already installs; try it: brewinstall . If you encounter any issues, run the command with the--debug switch like so: brew install --debug , which drops youinto a debugging shell.
If you want your new formula to be part of homebrew/core or wantto learn more about writing formulae, then please read the Formula Cookbook.
Can I install my own stuff to /usr/local?
Yes, brew is designed to not get in your way so you can use it how youlike.
Install your own stuff, but be aware that if you install commonlibraries like libexpat yourself, it may cause trouble when trying tobuild certain Homebrew formula. As a result brew doctor will warn youabout this.
Thus it's probably better to install your own stuff to the Cellar andthen brew link it. Like so:
Why was a formula deleted or disabled?
Use brew log to find out! Likely because it had unresolved issues and/or our analytics identified it was not widely used.
For disabled and deprecated formulae, running brew info will also provide an explanation.
Homebrew is a poor name, it's too generic, why was it chosen?
Homebrew's creator @mxcl was too concerned with the beer theme and didn't consider that the project may actually prove popular. By the time Max realised that it was popular, it was too late. However, today, the first Google hit for 'homebrew' is not beer related 😉
What does 'keg-only' mean?
It means the formula is installed only into the Cellar and is not linked into /usr/local. This means most tools will not find it. You can see why a formula was installed as keg-only, and instructions to include it in your PATH, by running brew info .
You can still link in the formula if you need to with brew link , though this can cause unexpected behaviour if you are shadowing macOS software.
How can I specify different configure arguments for a formula?
brew edit and edit the formula. Citrix receiver for windows 7. Currently there is noother way to do this.
The app can't be opened because it is from an unidentified developer
Chances are that certain apps will give you a popup message like this:
This is a security feature from Apple. The single most important thing to know is that you can allow individual apps to be exempt from that feature. This allows the app to run while the rest of the system remains under protection.
Always leave system-wide protection enabled, and disable it only for specific apps as needed.
If you are sure you want to trust the app, you can disable protection for that app by right-clicking its icon and choosing Open:
Finally, click the Open button if you want macOS to permanently allow the app to run on this Mac. Don't do this unless you're sure you trust the app.
Alternatively, you may provide the --no-quarantine flag at install time to not add this feature to a specific app.
Why some apps aren't included in upgrade
After running brew upgrade, you may notice some casks you think should be upgrading, aren't.
As you're likely aware, a lot of macOS software can upgrade itself:
That could cause conflicts when used in tandem with Homebrew Cask's upgrade mechanism.
If you upgrade software through it's built-in mechanism, that happens without Homebrew Cask's knowledge so both versions get out of sync. If you then upgraded through Homebrew Cask and we have a lower version on the software on record, you'd get a downgrade.
There are a few ideas to fix this problem:
- Try to prevent the software's automated updates. That won't be a universal solution and may cause it to break. Most software on Homebrew Cask is closed-source, so we'd be guessing. This is also why pinning casks to a version isn't available.
- Try to extract the installed software's version and compare it to the cask, deciding what to do at that time. That's a complicated solution that breaks other parts of our methodology, such as using versions to interpolate in
urls (a definite win for maintainability). That solution also isn't universal, as many software developers are inconsistent in their versioning schemes (and app bundles are meant to have two version strings) and it doesn't work for all types of software we support.
So we let software be. Installing it with Homebrew Cask should make it behave the same as if you had installed it manually. But we also want to support software that does not auto-upgrade, so we add auto_updates true to casks of software that can do it, which excludes them from brew upgrade.
Casks which use version :latest are also excluded, because we have no way to track the version they're in. It helps to ask the developers of such software to provide versioned releases (i.e. have the version in the path of the download url).
If you still want to force software to be upgraded via Homebrew Cask, you can:
- Reference it specifically in the
upgradecommand:brew upgrade. - Use the
--greedyflag:brew upgrade --greedy.
Refer to the upgrade section of the brew manual page by running man -P 'less --pattern '^ {3}upgrade' brew.
