1. 가장 쉬운 방법으로 다시 구동하는 방법은 무엇인가요?
2. S3 백업을 했다면 이미지, 메타데이터 등 관련 데이터를 모두 포함하고 있었나요?
이 글을 찾았지만, 5년 동안 업데이트가 되지 않았습니다:
오늘 더 이상 불필요한 일을 하기 전에, 누군가가 몇 가지 유용한 팁을 줄 수 있는지 확인하고 싶습니다. 누군가에게 가상 맥 한 잔을 사거나, 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 또는 다른 것에 대해 무료 조언을 드릴 수도 있습니다.
누군가 이 작업에 함께 참여(pair)할 시간이 있나요? 저는 그 과정을 문서화하겠습니다.
제가 아는 것은 다음과 같습니다:
- 제 discourse 디렉토리는
/var/discourse가 아니라/var/docker입니다. - S3에 최근 백업이 있습니다.
- ["templates/postgres.template.yml"을 "templates/postgres.9.5.template.yml"로 변경](http://Change “templates/postgres.template.yml” TO “templates/postgres.9.5.template.yml”)을 시도했습니다.
- 그런 다음 데이터베이스가 호환되지 않는 오류가 발생했습니다:
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.
관련 로그
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
