DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Newsletter
Log In / Join
Refcards Trend Reports
Events Video Library
Refcards
Trend Reports

Events

View Events Video Library

Related

  • PostgreSQL vs Oracle: When Higher Cost Means Better Performance
  • Why SQL Server Applications Break on PostgreSQL and How Compatibility Layers Fix It
  • Fix Circular Dependencies in PostgreSQL Row-Level Security With SECURITY DEFINER Functions
  • Seeding Postgres When Your Schema Has Foreign-Key Cycles

Trending

  • The Three Tiers of Agentic Incident Response: When to Trust AI Autonomy
  • PWA on iOS, Part 2: HTTPS, Manifest and Service Worker
  • RAG Architecture Patterns: Proxy, Caching, and Routing
  • The Permission Was Valid. The Action Was Not Authorized.

Draft This article hasn't been published, so readers can't see it.

In moderation This article is waiting for review, so readers can't see it yet.

Deleted This article has been deleted, so readers can't see it.

  1. DZone
  2. Data Engineering
  3. Databases
  4. Install Multiple Versions of PostgreSQL on Mac

Install Multiple Versions of PostgreSQL on Mac

In this post, we are going to use DBngin, a free tool for database version management on Mac.

By 
Tung Thanh
·
Sep. 06, 18 · Tutorial
Post on X (opens in a new tab) Share on LinkedIn (opens in a new tab)
10.4K Views

Join the DZone community Save articles, join the discussion, and download Refcards and Trend Reports with a free account.

Join for free Already a member? Log in

To install PostgreSQL on Mac, the two most common ways are Docker and Homebrew service. But Docker might be too big and eat up a large portion of memory, or sometimes you feel clumsy configuring the local server using the command line. On the other hand, it's really hard to install and manage multiple versions of PostgreSQL on your computer.

In this post, we are going to use DBngin, a free tool for database version management on Mac. It allows you to set up a local PostgreSQL server of any versions within a click.

  1. First, go to DBngin, and download and install the app on your Mac.

  2. Open DBngin and click on + New Server button.

  3. Choose PostgreSQL from the drivers' list; choose the PostgreSQL version and name your server to create a new server. You can edit the server and change the port later on.

Create a new local PostgreSQL server

Now you already have a local PostgreSQL server running on your computer.

With DBngin, you can install and manage multiple servers of not only PostgreSQL but MySQL, Redis. You can turn on and off any database server by just a click. Turn it on when you need and just quit when you're done. No dependencies.

Manage multiple servers

Thank you for viewing this quick tutorial on how to install PostgreSQL on your Mac using DBngin. Let me know your thoughts or any questions you might have regarding this tutorial in the comments section. Have a great day!

PostgreSQL

Opinions expressed by DZone contributors are their own.

Related

  • PostgreSQL vs Oracle: When Higher Cost Means Better Performance
  • Why SQL Server Applications Break on PostgreSQL and How Compatibility Layers Fix It
  • Fix Circular Dependencies in PostgreSQL Row-Level Security With SECURITY DEFINER Functions
  • Seeding Postgres When Your Schema Has Foreign-Key Cycles

Partner Resources

×

Comments

Loading comments

The comments didn't load

Please try again in a moment.

Likes

Loading

The next likes didn't load. Please try again.

The likes didn't load

Please try again in a moment.

See who liked this

Log in or join DZone for free to see who liked this article.

Log in Join for free
  • RSS
  • X
  • Facebook

ABOUT US

  • About DZone
  • Support and feedback
  • Community research

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Core Program
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 3343 Perimeter Hill Drive
  • Suite 215
  • Nashville, TN 37211
  • [email protected]

Let's be friends:

  • RSS
  • X
  • Facebook