Download iPostgreSqlProg - PostgreSql and enjoy it on your iPhone, iPad, and iPod touch. Are you a PostgreSql database user and ever wished about exploring the database from iOS devices by touch from anywhere, then this is a powerful companion tool for you to remotely visualize and explore the PostgreSql database in an intuitive way. Setting Up PostgreSQL on Mac OSX. Nov 13 th, 2014. In case you’re using this guide to get started using rails here’s how I would start the new rails app.
This is a quick guide for installing PostgreSQL (
Postgres
for short) on a Mac with Homebrew, and starting and stopping it with Lunchy. If you've just forked a Ruby on Rails project that requires Postgres, this tutorial will get you up and running in no time.Big mean folder machine v2 40. If you're working on a brand new Rails app and need to create a new Postgres user and database for your app, I recommend Will Jessop's tutorial or Peter Cooper's screencast.
Step 1: Install Homebrew
To make sure you have all the tools necessary for Ruby on Rails development, I recommend you follow my tutorial for installing Xcode, Homebrew, Git, RVM, and Ruby on a Mac.
Postgres Mac Applications
Step 2: Update Homebrew
Before you install anything with Homebrew, you should always make sure it's up to date and that it's healthy:
Step 3: Install Postgres
When you install Postgres, you will see a bunch of output in your Terminal that looks like this:
The important sections are
Build Notes
, Create/Upgrade a Database
, and Start/Stop PostgreSQL
. Make sure to follow those instructions to the letter.Step 4: Create/Upgrade a database
If this is your first time installing Postgres with Homebrew, you'll need to create a database with:
I copied and pasted that command directly from the Terminal output. You should do the same, in case the instructions change in the future.
Step 5: Install Lunchy
![Postgres Mac App Postgres Mac App](https://database.guide/wp-content/uploads/2020/06/Install_Postgres_app.jpg)
Phonerescue 3 7 0. Lunchy is a helpful gem that will allow you to easily start and stop Postgres.
![Postgres mac apple Postgres mac apple](https://dyclassroom.com/image/topic/howto-mac/mac-postgresql-postgresapp/postgres.app-start.jpg)
Step 6: Start/Stop Postgres
Once again, I'm copying and pasting the following commands from my Terminal. Note that the second command is specific to the version of Postgres that was installed on my machine. If the version number has changed since I've written this tutorial, using the command below won't work for you, so you should make sure to copy the command from your Terminal output.
Since we're using Lunchy, we don't need to run this third command:
Instead, we'll simply use this to start Postgres:
Postgres Mac App Download
At this point, you should be all set to run the
rake
commands to create and use the database for the existing Rails app you're working on.Uninstall Postgres App Mac
To stop Postgres: