1. Qual è il modo più semplice per ripartire?
2. Se ho eseguito backup su S3, questo ha coperto tutti i dati pertinenti, incluse immagini, metadati, ecc.?
Ho trovato questo articolo, ma non è stato aggiornato da 5 anni:
Quindi, prima di perdere altro tempo oggi, vorrei sapere se qualcuno può fornire alcuni consigli utili. Forse posso offrire una birra virtuale a qualcuno, dare qualche consiglio gratuito su GitHub - shakacode/react_on_rails: Integration of React + Webpack + Rails including server-side rendering of React, enabling a better developer experience and faster client performance. · GitHub o su altro?
C’è qualcuno disponibile a fare pair programming con me su questo, e io documenterò il lavoro svolto?
Ecco cosa so:
- La mia directory per Discourse è
/var/dockere non/var/discourse. - Ho un backup recente su S3.
- Ho provato a [cambiare “templates/postgres.template.yml” in “templates/postgres.9.5.template.yml”](http://Change “templates/postgres.template.yml” TO “templates/postgres.9.5.template.yml”)
- Successivamente il database non è compatibile:
2020-04-04 20:53:42.164 UTC [1601] FATAL: database files are incompatible with server
2020-04-04 20:53:42.164 UTC [1601] DETAIL: The data directory was initialized by PostgreSQL version 9.3, which is not compatible with this version 9.5.21.
Log pertinenti
Welcome to Ubuntu 16.04.3 LTS (GNU/Linux 4.4.0-148-generic x86_64)
System load: 0.08 Processes: 137
Usage of /: 69.3% of 29.40GB Users logged in: 0
Memory usage: 77% IP address for eth0: 192.241.224.165
Swap usage: 24% IP address for docker0: 172.17.0.1
187 packages can be updated.
19 updates are security updates.
*** System restart required ***
root@forum:~# cd /var/docker/
root@forum:/var/docker# git pull
Updating 67f34b8..b0c92ba
I, [2020-04-04T20:34:13.023086 #1] INFO -- : > apt-get update && apt-get install -y postgresql-9.3 postgresql-client-9.3 postgresql-contrib-9.3
E: Unable to locate package postgresql-client-9.3
E: Couldn't find any package by glob 'postgresql-client-9.3'
E: Couldn't find any package by regex 'postgresql-client-9.3'
E: Unable to locate package postgresql-contrib-9.3
E: Couldn't find any package by glob 'postgresql-contrib-9.3'
E: Couldn't find any package by regex 'postgresql-contrib-9.3'
I, [2020-04-04T20:34:17.590352 #1] INFO -- : Hit:1 http://deb.debian.org/debian buster InRelease
FAILED
--------------------
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"
159a5389071c2e398c9f426ae0853f11f662503190b648f0390fdb14dd9a057e
WARNING! This will remove all stopped containers.
Are you sure you want to continue? [y/N] y
Deleted Containers:
5fd4cef4498a5ad12efb2f27373e3950e83b106d8ab7095177862511b10a0366
Total reclaimed space: 1.494GB
WARNING! This will remove all images without at least one container associated to them.
Are you sure you want to continue? [y/N] y
Deleted Images:
untagged: local_discourse/app:latest
Total reclaimed space: 9.848GB
root@forum:/var/docker# df -h
Filesystem Size Used Avail Use% Mounted on
udev 477M 0 477M 0% /dev
tmpfs 100M 11M 89M 11% /run
/dev/vda1 30G 9.6G 19G 35% /
tmpfs 497M 0 497M 0% /dev/shm
tmpfs 5.0M 0 5.0M 0% /run/lock
tmpfs 497M 0 497M 0% /sys/fs/cgroup
cgmfs 100K 0 100K 0% /run/cgmanager/fs
tmpfs 100M 0 100M 0% /run/user/0
LOG: skipping missing configuration file "/shared/postgres_data/postgresql.auto.conf"
2020-04-04 20:53:42.164 UTC [1601] FATAL: database files are incompatible with server
2020-04-04 20:53:42.164 UTC [1601] DETAIL: The data directory was initialized by PostgreSQL version 9.3, which is not compatible with this version 9.5.21
FAILED
--------------------
Pups::ExecError: su postgres -c 'psql discourse -c "alter schema public owner to discourse;"' failed with return #<Process::Status: pid 1627 exit 2>
Location of failure: /pups/lib/pups/exec_command.rb:112:in `spawn'
exec failed with the params "su postgres -c 'psql $db_name -c \"alter schema public owner to $db_user;\"'"
e5ea7eeecd58ef02a19254a299700fe2146b447c6eda637a4fe64df373348953
