Monday, 9 July 2018

Complete Postgres installation step by step

           , ,      No comments   
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. If you don’t already have brew services installed. It may be installed with this command: brew services stop/start postgresql createuser -s postgres

Remove previous versions of PostgreSQL 

brew uninstall --force postgresql
Delete all Files of Postgres 

rm -rf /usr/local/var/postgres
Install Postgres using Homebrew 

brew install postgres
Start Postgres 

pg_ctl -D /usr/local/var/postgres start

or

brew services stop/start postgresql
download pgAdmin https://www.postgresql.org/ftp/pgadmin/pgadmin4/v2.0/macos/
Share:

0 comments:

Post a Comment

Popular Posts

  • Laravel Migrations Command Lines
    I don't trust my memory well so I'll document some migrations command php artisan make:migration add_paid_to_users --table=...
  • Using SQLite in Laravel Applications
     I have been playing with Laravel and MySQL just recently and I have been enjoying using it on one of my recent project.    It's an eCom...
  • Laravel Nova ReadOnly Problems
     On Laravel Nova,   when creating record field with readonly and default values are not submitted.  This is the correct way to work around i...
  • Javascript Example To Call an Ajax
    Example code in javascript to call an ajax function changeDeliveryTime() { var deliveryMethod = $('#deliveryMethod').val()...
  • Understanding Laravel Return set
    Difference between Laravel Eloquent, DB Raw, Json Encode and Json Decode result set. If you're using a DB:select raw command $curre...
  • The Date Problem for Laravel and Regional Settings
    For every Laravel application birthday should be displayed as it was saved. It should have a type 'date' and those 'created_at...
  • Country Package for Laravel
    It is often or not we need a country listing in our package to display in the view or dropdown HTML component. Instead of creating table of ...
  • Laravel Rule Validations
    Laravel validations $errorMessage = "NFL Competition already exist for year $this->year and with the selected competition type....
  • Some Interview Question
    What was your bigger achievement? "I have several notable accomplishments in my career. Probably the most notable accomplishment was t...
  • Complex Laravel Eloquent Example
    select n0y_t_item_description.s_title, n0y_t_item_description.s_slug as item_slug, n0y_t_item.d_price as price, n0y_t_category_d...

Recent Posts

Pages

Powered by Blogger.

About Me

My photo
For the past 10 years, I've been playing with codes using PHP, Java, Rails. I do this for a living and love new things to learn and the challenges that comes with it. Besides programming I love spending time with friends and family and can often be found together catching the latest movie or planning a trip to someplace I've never been before.