#Install and run postgresql mac ruby how to
#Install and run postgresql mac ruby install
#Install and run postgresql mac ruby update
#Install and run postgresql mac ruby password

Update 3: > pg_ctl -D /usr/local/var/postgres status Is the server running on host 'localhost' and accepting The touch was not successful, so I did this instead: > mkdir /usr/local/var/postgresīut when I try to start the Ruby on Rails server, I still see this: Sh: /usr/local/var/postgres/server.log: No such file or directory Update: > pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start I see that postgres is not running > ps auxwww | grep postgres # Do not set this db to the same as development or production.I had forgotten to run the initdb command.īy running this command ps auxwww | grep postgres

#Install and run postgresql mac ruby password

New (For PostgreSQL): default : &default adapter : postgresql encoding : unicode pool : 5 host : localhost username : password : development : << : *default database : # Warning: The database defined as 'test' will be erased and # re-generated from your development database when you run 'rake'. test : << : *default database : db/test.sqlite3 production : << : *default database : db/production.sqlite3 # Do not set this db to the same as development or production.

#Install and run postgresql mac ruby install

Original (for SQLite): # SQLite version 3.x # gem install sqlite3 # Ensure the SQLite 3 gem is defined in your Gemfile # gem 'sqlite3' # default : &default adapter : sqlite3 pool : 5 timeout : 5000 development : << : *default database : db/development.sqlite3 # Warning: The database defined as 'test' will be erased and # re-generated from your development database when you run 'rake'.

#Install and run postgresql mac ruby update

Open config/database.yml file and update it like the following: Gem install pg -with-pg-config=/Library/PostgreSQL/9.4/bin/pg_config Install the gem with pg-config path explicitly specified. By default, it should be /Library/PostgreSQL/9.4/bin/pg_config for PostgreSQL 9.4. If not, manually add a server pointing to localhost:5432 or the port number specified when installing PostgreSQL.įind out where pg_config is using the command below.

The local DB should be already shown up in Obeject Browser -> Server Groups -> Servers -> PostgreSQL 9.4 (localhost:5432).

Open up pgAdmin III from the applications.

It helps users manage PostgreSQL databases through graphical interfaces. PgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL. bash_profile using the PostgreSQL's binary path. Open ~/.bash_profile with following command.Īdd the following line to. Otherwise, use the following find command to find the path. By default, it should be /Library/PostgreSQL/9.4/bin/psql, where 9.4 is the PostgreSQL version number.

Installing Stack Builder is optional and can be omitted.

Follow through the installation wizard with the default options.

Install from the downloaded file postgresql-9.4.0-1-osx.dmg just like any other Mac installers.

(For example, the latest installer version is Version 9.4.0). This grapichal installer provides an easy and straightforward wizard to get Postgres installed with few simple clicks. However, as I also use Linux and Windows machines for development, installing PostgreSQL using grapichal installer from EnterpriseDB would be a more widely used solution that keeps everything consistent across all my environment. Homebrew or Postgres.app are the common ones that often recommeded by other Mac users. Install PostgreSQLĪs shown in the official Postgres download instructions here, there are few ways of installing PostgreSQL on Mac OS. This note assumes that Ruby on Rails has already been properly installed and the purpose is to replace the default DB engine SQLite with PostgreSQL.

#Install and run postgresql mac ruby how to

A brief note on how to install and setup PostgreSQL for Ruby on Rails on Mac OS.