Introduction
Sql Manager Lite For Postgresql
PostgreSQL is an open-source, object-relational database management system (ORDBMS) available for all major platforms including Linux, UNIX, Windows, and OS X. It allows you to add custom functions developed using different programming languages such as C/C, Java, etc. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent. This is a step-by-step guide to install PostgreSQL on a Mac OS machine. We will be installing PostgreSQL version 11.3 on Mac using the installer provided by EnterpriseDB in this article. There are three crucial steps for the installation of PostgreSQL as follows: Step 2: Choose the installation.
Postgres is a powerful and free object-relational database management system. It has gained a lot of momentum since its introduction in 1995 because of its robustness and powerful features it ships with out of the box. In this article, we’ll walk through the process of installing a Postgres database on a Mac OS X machine and set it up for Ruby on Rails development.
Install Postgres Database with Homebrew
Homebrew is a popular package manager for OS X. To install Postgres with Homebrew, follow the steps below:
The first thing to do is install Homebrew if you haven’t done so already. Homebrew site has a simple command that you have to paste in your terminal to do so. Make sure to accept the command line developer tools installation if prompted.
Next, run
brew install postgres
to install Postgres. It might take a little while to compile and install. After compilation is done, it’ll give you some instructions to finish setting it up.The database will be initialized during installation, so there isn’t a need to run
initdb
to finish installation of Postgres via Homebrew. Near the end of the installation instructions you should see mention of the command brew services
.![Mac Mac](/uploads/1/3/3/9/133960996/953511767.png)
If you don’t already have
brew services
installed. It may be installed withthis command:And then you can run the following command to start Postgres as a background service:
Mac Postgresql Client
Postgres will also restart automatically at login after you have run the command above.
Once Postgres has started, we can use
Once Postgres has started, we can use
brew services
to stop it manually:Or we can also use
brew services
to restart Postgres:Now you should have PostgreSQL all set up.
Set Up Postgres to Work with a Rails App
First, install the
pg
gem:Make sure you include the
pg
gem in your Gemfile, and runNow, set up your
config/database.yml
file to point to your Posgres database.![Mac install postgresql Mac install postgresql](/uploads/1/3/3/9/133960996/523496039.png)
Let’s create the development and test databases:
Now you can run pending migrations, if there are any.