tereensio
(Tere Vadén)
January 21, 2020, 10:00am
1
Hi
– trying to manually update old Discourse by these instructions
This guide provides step-by-step instructions for manually updating Discourse, the Docker container, and the Ubuntu operating system on a self-hosted setup.
Required user level: System Administrator
SSH access to the server.
If you self-host Discourse, you occasionally need to run a manual update via the command line to get the latest security releases and newest libraries.
These updates are not picked up in admin/upgrade, which is why you’ll occa…
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)
January 21, 2020, 10:59am
2
tereensio:
postgresql-9.3
How old is your Discourse install? On what version are you?
tereensio
(Tere Vadén)
January 21, 2020, 11:21am
3
seems to be [v1.9.0.beta17 +38]
JimPas
January 23, 2020, 5:59am
4
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)
January 23, 2020, 7:50am
5
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?
Maybe it is related to this issue:
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)
January 23, 2020, 8:19am
6
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)
January 23, 2020, 1:12pm
7
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:
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)
January 23, 2020, 1:21pm
8
"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)
January 23, 2020, 1:24pm
9
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)
January 23, 2020, 1:33pm
10
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)
January 23, 2020, 1:54pm
11
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)
January 23, 2020, 1:56pm
12
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.