Cannot upgrade Postgres to 9.5
-
Hello @SuperSajuuk First of all, I need to note that we only support the PostgreSQL version which is shipped with the OS which at this time is 9.2. This is also noted in our documentation here: Install or Update PostgreSQL on Your cPanel Server - cPanel Knowledge Base - cPanel Documentation Secondly what you're linking is very old and it's possible the steps the user took there are no longer valid. We can't guarantee reliability on customizations which we do not support. That being said what is the error you're getting exactly? When you run the following: systemctl stop postgresql
Then run the following:ps faux |grep post
Do you continue to see PostgreSQL processes running?0 -
Hi there @cPanelLauren That's just it: there is no error being printed by the upgrade tool, it just fails for no apparent reason. I was able to revert everything back to 9.2 (with only one minor issue being observed with one database) after a lot of issues and random corruption of databases / failing imports, and most likely I did a step incorrectly when performing the initial upgrade to 9.5 (I don't believe I really need to upgrade, as the only primary reason is to be able to use the ON CONFLICT feature: I may be able to use a different method that does something similar without it though). When I do the `stop` request to the service, no postgres services were running as per the requirements of pg_upgrade, but I get no errors, just a "failure, exiting" and the command stops. As said though, I probably made an error when performing the upgrade (like moving the files instead of copying them) which probably broke the relations. Will keep trying and report back using the guide I linked, since it mostly worked barring this one error which may be specific to my system, so chances are I just did something wrongly :D 0 -
Ok, well let us know if you have any questions or issues if you do try an upgrade again, we'll do our best to assist! 0
Please sign in to leave a comment.
Comments
3 comments