Upgrade Postgres 9.4 to 9.6 in MAC.

Postgres 9.6.1 is the current Postgres version, if you want to upgrade the Postgres version in mac it very easy now using homebrew.

Just follow the below steps
Step 1: Turn PostgreSQL off first:
    $ launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
    # or, if you're running a current version of Homebrew
    $ brew services stop postgresql

Step 2: Update brew and upgrade Postgres
    $ brew update && brew upgrade postgresql

Step 3: Initialize the new empty database
   $ initdb /usr/local/var/postgres9.6.1 -E utf8

Step 4: When we update check the currently available version of the system
    $ ls /usr/local/Cellar/postgresql/
Which gives you output something like this: 9.4, 9.5.0, 9.6.1 If you have more than two, that’s ok, just get the most recent one (9.6.1) and the last before 9.5.0. Remember that version for the next step.

Step 5: Upgrade the version
$ pg_upgrade \
  -d /usr/local/var/postgres \
  -D /usr/local/var/postgres9.6.1 \
  -b /usr/local/Cellar/postgresql/9.5.0/bin/ \
  -B /usr/local/Cellar/postgresql/9.6.1/bin/ \
  -v

Step 6: Next, move the new directory to where postgres expects it to be.
     $ mv /usr/local/var/postgres /usr/local/var/postgres-9.5.0
     $ mv /usr/local/var/postgres9.6.1 /usr/local/var/postgres

Step 7: Run the postgres once again
    $ brew services start postgresql

 That's it our upgradations process is completed now.
REF LINKS:  link_1, link_2

Comments

Post a Comment

Popular posts from this blog

Debug Nodejs inside docker container

If you want to debug a node js or express application that is running inside a docker container please follow the below steps. Step1:   add pryjs in you package.json and run npm install    or    npm install --save pryjs Step 2:   Go to your docker-compose file and find the specific docker container which you want to debug.   Ex. if your container name is an app then please add the below lines   app:     stdin_open: true     tty: true Step 3:   Go the specific file where you want to debug and require the library     var pry = require('pryjs');   Then add the script to the specific like where you want to stop the execution.     eval(pry.it) Step 4:   Run the docker compose file and attach the specific process     docker-compose up -d && docker attach $(docker-compose ps -q app) It will stop the execution in the specific line once the request will hit that specific line Please check the documentation for a more pry option.
Read more

Swap primary keys between two records in the same table in Postgres

What if we need to swap two primary keys on the same table? What's the best and efficient way to do the same? let's check Now:- Let's assume we have a user table which has 3 columns among all the rows I have taken two sample rows which are the target rows for us. Id Name Email 101 Sabyasachi XX@gmail.com 105 Saghosh xxx@gmail.com We need to swap the primary keys (which are unique by nature) between those two records so our desired result will be something like   Id Name Email 105 Sabyasachi XX@gmail.com 101 Saghosh xxx@gmail.com Now lets buield a query using CTE(common table expression) to solve the problem:- with source_user as (   select     id   from     users   where     id = 101 ), destination_user as (   select     id   from     users   where     id
Read more

How to add a bootstrap table with fixed header and scrollable body

I am pretty sure that everyone is familiar with bootstrap CSS, if not please take a look(bootstrap). Now Bootstrap has lots of different components and table styling is one of them and they have plenty of different styling options. Now sometimes if we have to display a large amount of data inside a table, the user will have to scroll till the end of the table and after few scroll, they can not see the table header. There is a way to fix this. Please follow the below steps. Step1: Create a bootstrap table first <table class="table table-fixed">   <colgroup></colgroup>   <colgroup class=""></colgroup>   <thead>   <tr>     <th>       <label>         ##       </label>     </th>     <th>       <label class="">         ###       </label>     </th>   </tr>   </thead>   <tbody id="fixed-height">       <tr>         &
Read more