Pak Jiddat

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