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. Using Rsync over custom SSH port
  2. Installing latest version of Php
  3. Upgrading MySQL server from version 5.6 to 8.0
  4. Upgrading R from version 3.0 to 3.5
  5. Backing up and restoring LXD containers
  6. Resizing Linux root partitions without unmount on Google Cloud
  7. Running multiple versions of mailx command
  8. Getting /etc/rc.local file to work on Debian 9 (Stretch)
  9. Increasing number of concurrent connections for Proftp
  10. Changing ownership of symbolic link
  11. Configuring Apache to process html files as php
  12. Php server APIs
  13. Apache Multi Processing Modules (MPMs)
  14. Calculating the number of simultaneous connections supported by Apache
  15. Problem with copying large files to USB
  16. Monitoring RAM usage on server
  17. Finding CPU usage using top command
  18. Format of crontab file
  19. Force grub2 to not use UUID
  20. Automate scp command using sshpass
  21. Using PSCP command for copying files and directories
  22. Installing Docker on Debian Jessie
  23. Rocket Chat migration error
  24. Rocket Chat startup script
  25. Upgrading Rocket Chat to latest version
  26. Installing modules in Odoo 10.0
  27. Installing NodeJS on Ubuntu
  28. Installing W3C Markup Validator on Debian Jessie
  29. Ignoring errors during MySQL import
  30. MariaDB/MySQL user password not being set
  31. Sorting a MySQL string column as a number
  32. MySQL server out of resources
  33. MySQL Tuner
  34. Create backup of Mongo Db database
  35. Deleting a Mongo Db database
  36. Restoring a database backup in Plesk
  37. How to login to MySQL server as root user on Plesk
  38. List all databases for Postgresql
  39. Solution for mysql header mismatch error
  40. Backing up and Restoring MongoDB data
  41. Removing Replication in MongoDb
  42. Exporting Mysql database data in CSV format using Mysql Work Bench