Brew install wtfutil on Catalina: 'exec format error' #765. Macintacos opened this issue on Nov 26, 2019 8 comments. Dependency issue. Senorprogrammer added the bug label on Nov 26, 2019. Senorprogrammer added dependency issue and removed bug labels on Dec 13, 2019. Install command: brew install boost. Also known as: boost@1.76. Collection of portable C source libraries.

On Catalina/Big Sur/etc. You can use homebrew to install either wine-stable or wine-devel (to see all available options run brew search wine). At the moment of writing wine-stable was still too buggy so I went instead with wine-devel. So I'm running macOS 10.15.2 Catalina and try to install mariadb (10.4.11, the lastest version) with Homebrew. After running brew install mariadb, brew warned that the postinstalllation didn't complete successfully. Installing Homebrew. First, we need to install Homebrew. Homebrew allows us to install and compile software packages easily from source. Homebrew comes with a very simple install script. When it asks you to install XCode CommandLine Tools, say yes. Open Terminal and run the following command.

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.

How To Install Homebrew On Catalina

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

Install Brew On Catalina Mac

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.

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.

Cannot Install Homebrew On Catalina

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 :-)