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
  19. Using PSCP command for copying files and directories
  20. Installing Docker on Debian Jessie
  21. Upgrading Rocket Chat to latest version
  22. Rocket Chat startup script
  23. Rocket Chat migration error
  24. Installing modules in Odoo 10.0
  25. Installing NodeJS on Ubuntu
  26. Installing W3C Markup Validator on Debian Jessie
  27. Ignoring errors during MySQL import
  28. MariaDB/MySQL user password not being set
  29. Sorting a MySQL string column as a number
  30. MySQL server out of resources
  31. MySQL Tuner
  32. Create backup of Mongo Db database
  33. Deleting a Mongo Db database
  34. How to login to MySQL server as root user on Plesk
  35. Restoring a database backup in Plesk
  36. List all databases for Postgresql
  37. Solution for mysql header mismatch error
  38. Backing up and Restoring MongoDB data
  39. Removing Replication in MongoDb
  40. Exporting Mysql database data in CSV format using Mysql Work Bench