Pak Jiddat - Innovative Software Services

Read: In the name of thy Lord Who createth, Createth man from a clot. Read: And thy Lord is the Most Bounteous, Who teacheth by the pen, Teacheth man that which he knew not. Nay, but verily man is rebellious That he thinketh himself independent!. Lo! unto thy Lord is the return. (Sura Alalaq 96:8)

Upgrading Postgresql from version 9.4 to 9.6

Created On: 28 Jun, 2018: 16:08:41 - Tags : server management | software installation | database management


Debian Stretch does not support Postgresql version 9.4 which is provided by Debian Jessie. To upgrade Postgresql from 9.4 to 9.6, I followed the instructions given on: Upgrade postgresql on Debian Jessie with pg_upgradecluster. Although the instructions are for upgrading from version 9.1 to 9.4, they work for upgrading from 9.4 to 9.6. To upgrade from 9.4 to 9.6, we need to first install Postgresql 9.6 using the command: sudo apt-get install postgresql-9.6

Next we need to drop the main cluster created during installation of 9.6. We can do this with the command: sudo pg_dropcluster --stop 9.6 main

Next we need to stop the postgresql-9.4 with the command: service postgresql stop. After that we need to upgrade the cluster from version 9.4 to 9.6 using the command: pg_upgradecluster -v 9.6 9.4 main. After that we can remove the postgresql-9.4 with the command: apt-get remove postgresql-9.4

Related Articles

  1. Installing latest version of Php
  2. Upgrading MySQL server from version 5.6 to 8.0
  3. Upgrading R from version 3.0 to 3.5
  4. Backing up and restoring LXD containers
  5. Resizing Linux root partitions without unmount on Google Cloud
  6. Running multiple versions of mailx command
  7. Getting /etc/rc.local file to work on Debian 9 (Stretch)
  8. Increasing number of concurrent connections for Proftp
  9. Changing ownership of symbolic link
  10. Configuring Apache to process html files as php
  11. Php server APIs
  12. Apache Multi Processing Modules (MPMs)
  13. Calculating the number of simultaneous connections supported by Apache
  14. Problem with copying large files to USB
  15. Monitoring RAM usage on server
  16. Finding CPU usage using top command
  17. Format of crontab file
  18. Force grub2 to not use UUID