How to Install PostgreSQL on macOS

Installing PostgreSQL on your Mac can be a bit tricky, but with these simple steps, you'll have it up and running in no time. In this article, we will guide you through the process of installing PostgreSQL on your Mac using Homebrew.

Step 1: Start the PostgreSQL Server

Before you begin, make sure to start the PostgreSQL server by running the command `pg-start` in your terminal. This will initiate the process of starting the server. You can verify that it is running by checking its status with the command `pg-status`.

Step 2: Create Aliases for Convenience

To avoid having to type out long commands every time you want to start, stop or restart the PostgreSQL service, you can create aliases in your user's bash profile. To do this, open your current user's bash profile using the command `nano ~/.bash_profile`. Add the following lines to the end of the file:

```

alias pg-start='brew services start postgresql'

alias pg-stop='brew services stop postgresql'

alias pg-restart='brew services restart postgresql'

alias pg-status='pg_ctl -D /usr/local/var/postgres status'

```

This will enable you to use shorter commands like `pg-start` or `pg-stop` to manage your PostgreSQL service.

Step 3: Install PostgreSQL

To install PostgreSQL, run the command `brew install postgresql`. This will download and install the latest version of PostgreSQL available. You can check which version is being installed by looking at line #1 of the output, which should display the version number, such as 'stable 11.2'.

Step 4: Migrate Existing Data (Optional)

If you have existing data from a previous major version of PostgreSQL, you may need to migrate it before upgrading. To do this, use the command `postgres-xc` (since PostgreSQL and Postgres-xc install the same binaries).

Step 5: Check the Version

To check which version of PostgreSQL is installed on your Mac, run the command `brew info postgresql`. This will display information about the latest available version.

Installing PostgreSQL on your Mac with Homebrew is a relatively straightforward process. By following these simple steps, you can get up and running with PostgreSQL in no time. Whether you're looking to create aliases for convenience or migrate existing data, this guide has covered everything you need to know to get started with PostgreSQL on your Mac.

Macos install psql