Manual upgrade fails

[tereensio (Tere Vadén)]

Hi

– trying to manually update old Discourse by these instructions

Manually update Discourse and Docker image to latest

If you self-host Discourse, you occasionally need to run a manual update via the command line to get the latest security releases newest libraries. These updates are not picked up in admin/update, which is why you’ll occasionally need to do this additional step. Discourse itself should be updated about twice a month, by clicking the “Update to Latest Version” button in your admin dashboard (admin/update). Every two months we recommend SSH’ing into your web server (using putty or your favor…

Keep getting this error:

Pups::ExecError: apt-get update && apt-get install -y postgresql-9.3 postgresql-client-9.3 postgresql-contrib-9.3 failed with return #<Process::Status: pid 18 exit 100>

Location of failure: /pups/lib/pups/exec_command.rb:112:in `spawn’

exec failed with the params “apt-get update && apt-get install -y postgresql-9.3 postgresql-client-9.3 postgresql-contrib-9.3”

a2bd7274278e546582a98ef46371b18564f416c2cadaa46a6ec6c58a5a3f162f

** FAILED TO BOOTSTRAP ** please scroll up and look for earlier error messages, there may be more than one.

./discourse-doctor may help diagnose the problem.

I upgraded to Ubuntu 18.04.3 LTS and added disk size well above double the db size.

Any ideas?

[RGJ (Richard - Communiteq)]

@tereensio

postgresql-9.3

How old is your Discourse install? On what version are you?

[tereensio (Tere Vadén)]

seems to be [v1.9.0.beta17 +38]

[JimPas]

Time for an upgrade. Discourse is up to v2.4.0.beta10.
There have been a lot of changes, updates, improvements, etc.

[Remah (Just another happy Discourse user)]

Have you got it working?

I have no expertise in this area but it looks like it is failing when trying to get Postgres 9.3.

But that was upgraded to 9.5 back in 2016 and you are using Discourse version 1.9 which is from 2018?

Something seems to have gone wrong with my update

We updated our docker image to Postgres 9.5 back in May 2016 https://meta.discourse.org/t/discourse-docker-image-version-1-3-3-released/44778

Maybe it is related to this issue:

Trouble upgrading PostgreSQL from 9.3 to current

Continuing the discussion from Discourse Docker Image version 1.3.3, released: So, I have been using postgres 9.3 since the new docker image came out… and just replacing templates/postgres.9.3.template.yml with templates/postgres.template.yml doesn’t work. Given a current backup, what’s a good way to upgrade the postgres template?

Right now I don’t have time to read these topics. I just noticed no help for 2 days.

[tereensio (Tere Vadén)]

Time for an upgrade. Discourse is up to v2.4.0.beta10.
There have been a lot of changes, updates, improvements, etc.

Yes. I’m trying to upgrade. The problem is that the upgrade fails.

In just want an up-to-date Discourse, with the old stuff preserved.

How to do that?

[Remah (Just another happy Discourse user)]

I don’t understand why you are using an older version of PostgreSQL than would have been installed or upgraded for [v1.9.0.beta17 +38]

Did you install by some method other than the official Discourse install method? See the official install method at discourse/docs/INSTALL.md at main · discourse/discourse · GitHub

Whatever you do make sure that you have a backup.

Check that you have enough disk space for the PostgreSQL upgrade. They say you need free space twice the size of the database:

Issue Rebuilding App Failing on Postgres Upgrade

Trying to do a launcher rebuild and getting this error I, [2018-06-30T18:56:08.346656 #17] INFO -- : I, [2018-06-30T18:56:08.346728 #17] INFO -- : > chown -R postgres:postgres /shared/postgres_data I, [2018-06-30T18:56:08.357457 #17] INFO -- : I, [2018-06-30T18:56:08.357700 #17] INFO -- : > chown -R postgres:postgres /var/run/postgresql I, [2018-06-30T18:56:08.359892 #17] INFO -- : I, [2018-06-30T18:56:08.360109 #17] INFO -- : > /root/upgrade_postgres I, [2018-06-30T18:56:08.374537 #17] …

The other two topics I posted previously may also help but I’m not sure of the source of your problem.

[tereensio (Tere Vadén)]

"I don’t understand why you are using an older version of PostgreSQL than would have been installed or upgraded for [v1.9.0.beta17 +38]

Did you install by some method other than the official Discourse install method? See the official install method at discourse/INSTALL.md at master · discourse/discourse · GitHub"

Me neither.

I have upgraded via the /admin section at the webservice.

Now the webservice says I have to update manually.

Manual upgrade fails.

That is the situation.

I wonder of there is a way to manually upgrade PostgreSQL first, then try to upgarde Disocurse. Would that work?

[RGJ (Richard - Communiteq)]

That PG 9.3 is really old, and it doesn’t sound right for a v1.9 Discourse install.

If I were you I would make a backup, create a new host with an up to date Discourse, restore the backup and move the hostname to the new server.

[pfaffman (Jay Pfaffman)]

Do you have a separate data container or are you using an external database?

In any case, I would first try the route that Richard just suggested.

[tereensio (Tere Vadén)]

Do you have a separate data container or are you using an external database?

How can I tell? I mean, how do I know/find out?

[tereensio (Tere Vadén)]

If I were you I would make a backup, create a new host with an up to date Discourse, restore the backup and move the hostname to the new server.

Ok, I think I’ll try this.