최신 버전으로 업데이트: ./analyze_new_cluster.sh 메시지

제품 지원 자체 호스팅
1

안녕하세요

오늘 다음과 같이 Discourse를 업그레이드했습니다:

apt-get update
apt-get upgrade
./launcher rebuild app

그 후 다음과 같은 출력이 나타났습니다:

Setting next OID for new cluster                            ok
Sync data directory to disk                                 ok
Creating script to analyze new cluster                      ok
Creating script to delete old cluster                       ok

Upgrade Complete
----------------
Optimizer statistics are not transferred by pg_upgrade so,
once you start the new server, consider running:
    ./analyze_new_cluster.sh

Running this script will delete the old cluster's data files:
    ./delete_old_cluster.sh
-------------------------------------------------------------------------------------
UPGRADE OF POSTGRES COMPLETE

Old 10 database is stored at /shared/postgres_data_old

To complete the upgrade, rebuild again using:

./launcher rebuild app
-------------------------------------------------------------------------------------

물론 ./analyze_new_cluster.sh를 실행하려고 하면 해당 파일이 존재하지 않습니다:

./analyze_new_cluster.sh
-su: ./analyze_new_cluster.sh: No such file or directory

이제 Discourse가 로드되지 않습니다.

Postgres 업그레이드 관련 문제인 것 같지만, 문제를 더 악화시킬까 봐 크게 건드리고 싶지 않습니다.

어떻게 해야 할까요? 미리 감사합니다.

2

제안대로 ./launcher rebuild app 명령을 한 번 더 실행하세요. 이렇게 하면 웹사이트가 다시 온라인으로 복구됩니다.

자세한 내용은 공지사항을 확인해 주세요.

4

다음 지침을 따르기 전까지는 Discourse가 로드되지 않습니다.

5

@Falco @itsbhanusharma 님 안녕하세요

여러 번 시도해 보았지만 작동하지 않습니다: https://chat.commedia.org.uk

저장 공간은 충분합니다:

root@chat:/var/discourse# df -h
Filesystem      Size  Used Avail Use% Mounted on
udev            990M  4.0K  990M   1% /dev
tmpfs           201M  420K  200M   1% /run
/dev/vda1        40G   11G   28G  28% /
none            4.0K     0  4.0K   0% /sys/fs/cgroup
none            5.0M     0  5.0M   0% /run/lock
none           1001M     0 1001M   0% /run/shm
none            100M     0  100M   0% /run/user

다음과 같은 출력이 대량으로 표시됩니다:

Success. You can now start the database server using:

    pg_ctlcluster 10 main start

Warning: The selected stats_temp_directory /var/run/postgresql/10-main.pg_stat_tmp
is not writable for the cluster owner. Not adding this setting in
postgresql.conf.
Ver Cluster Port Status Owner    Data directory              Log file
10  main    5433 down   postgres /var/lib/postgresql/10/main /var/log/postgresql/postgresql-10-main.log
update-alternatives: warning: forcing reinstallation of alternative /usr/share/postgresql/12/man/man1/postmaster.1.gz because link group postmaster.1.gz is broken
invoke-rc.d: could not determine current runlevel
invoke-rc.d: policy-rc.d denied execution of start.
Processing triggers for postgresql-common (213.pgdg100+1) ...
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
Stopping PostgreSQL 10 database server: main.
Stopping PostgreSQL 12 database server: main.
Performing Consistency Checks

따라서 제안대로 데이터베이스 서버를 시작하려고 시도해 보았습니다:

root@chat:/var/discourse# pg_ctlcluster 10 main start
The program 'pg_ctlcluster' is currently not installed. You can install it by typing:
apt-get install postgresql-common

불행히도 저는 Postgres에 대해 전혀 알지 못합니다. 제 생각에는 Postgres가 실행되지 않는 것 같습니다:

root@chat:/var/discourse# netstat -tulpn
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      21236/sshd
tcp        0      0 0.0.0.0:25              0.0.0.0:*               LISTEN      1258/master
tcp6       0      0 :::25                   :::*                    LISTEN      1258/master

그러므로 Postgres를 시작해야 합니다.

이것은 어떻게 하면 될까요?

미리 감사드립니다.

6

재구성이 성공적으로 완료되었나요?

7

Hi @itsbhanusharma - 감사합니다.

루프에 걸려 있습니다. 전체 로그를 게시할게요 - 길어요…

root@chat:/var/discourse# ./launcher rebuild app
WARNING: Docker version 17.05.0-ce deprecated, recommend upgrade to 17.06.2 or newer.
Ensuring launcher is up to date
Fetching origin
Launcher is up-to-date
Stopping old container
+ /usr/bin/docker stop -t 60 app
app
cd /pups && git pull && /pups/bin/pups --stdin
Already up to date.
I, [2020-05-16T20:14:12.296784 #1]  INFO -- : Loading --stdin
I, [2020-05-16T20:14:12.306278 #1]  INFO -- : > locale-gen $LANG && update-locale
I, [2020-05-16T20:14:12.361144 #1]  INFO -- : Generating locales (this might take a while)...
Generation complete.

I, [2020-05-16T20:14:12.362602 #1]  INFO -- : > mkdir -p /shared/postgres_run
I, [2020-05-16T20:14:12.370202 #1]  INFO -- :
I, [2020-05-16T20:14:12.371006 #1]  INFO -- : > chown postgres:postgres /shared/postgres_run
I, [2020-05-16T20:14:12.375175 #1]  INFO -- :
I, [2020-05-16T20:14:12.375931 #1]  INFO -- : > chmod 775 /shared/postgres_run
I, [2020-05-16T20:14:12.379105 #1]  INFO -- :
I, [2020-05-16T20:14:12.379729 #1]  INFO -- : > rm -fr /var/run/postgresql
I, [2020-05-16T20:14:12.383254 #1]  INFO -- :
I, [2020-05-16T20:14:12.383840 #1]  INFO -- : > ln -s /shared/postgres_run /var/run/postgresql
I, [2020-05-16T20:14:12.386523 #1]  INFO -- :
I, [2020-05-16T20:14:12.387099 #1]  INFO -- : > socat /dev/null UNIX-CONNECT:/shared/postgres_run/.s.PGSQL.5432 || exit 0 && echo postgres already running stop container ; exit 1
2020/05/16 20:14:12 socat[25] E connect(6, AF=1 "/shared/postgres_run/.s.PGSQL.5432", 36): No such file or directory
I, [2020-05-16T20:14:12.394135 #1]  INFO -- :
I, [2020-05-16T20:14:12.394564 #1]  INFO -- : > rm -fr /shared/postgres_run/.s*
I, [2020-05-16T20:14:12.398513 #1]  INFO -- :
I, [2020-05-16T20:14:12.398998 #1]  INFO -- : > rm -fr /shared/postgres_run/*.pid
I, [2020-05-16T20:14:12.403169 #1]  INFO -- :
I, [2020-05-16T20:14:12.403815 #1]  INFO -- : > mkdir -p /shared/postgres_run/12-main.pg_stat_tmp
I, [2020-05-16T20:14:12.407199 #1]  INFO -- :
I, [2020-05-16T20:14:12.407819 #1]  INFO -- : > chown postgres:postgres /shared/postgres_run/12-main.pg_stat_tmp
I, [2020-05-16T20:14:12.410921 #1]  INFO -- :
I, [2020-05-16T20:14:12.418703 #1]  INFO -- : File > /etc/service/postgres/run  chmod: +x  chown:
I, [2020-05-16T20:14:12.427152 #1]  INFO -- : File > /etc/service/postgres/log/run  chmod: +x  chown:
I, [2020-05-16T20:14:12.435570 #1]  INFO -- : File > /etc/runit/3.d/99-postgres  chmod: +x  chown:
I, [2020-05-16T20:14:12.443806 #1]  INFO -- : File > /root/upgrade_postgres  chmod: +x  chown:
I, [2020-05-16T20:14:12.444617 #1]  INFO -- : > chown -R root /var/lib/postgresql/12/main
I, [2020-05-16T20:14:12.569836 #1]  INFO -- :
I, [2020-05-16T20:14:12.570782 #1]  INFO -- : > [ ! -e /shared/postgres_data ] && install -d -m 0755 -o postgres -g postgres /shared/postgres_data && sudo -E -u postgres /usr/lib/postgresql/12/bin/initdb -D /shared/postgres_data || exit 0
I, [2020-05-16T20:14:12.576273 #1]  INFO -- :
I, [2020-05-16T20:14:12.576766 #1]  INFO -- : > chown -R postgres:postgres /shared/postgres_data
I, [2020-05-16T20:14:12.619127 #1]  INFO -- :
I, [2020-05-16T20:14:12.619869 #1]  INFO -- : > chown -R postgres:postgres /var/run/postgresql
I, [2020-05-16T20:14:12.624778 #1]  INFO -- :
I, [2020-05-16T20:14:12.625363 #1]  INFO -- : > /root/upgrade_postgres
initdb: warning: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
debconf: delaying package configuration, since apt-utils is not installed
mv: cannot move '/shared/postgres_data' to '/shared/postgres_data_old/postgres_data': Directory not empty
mv: cannot move '/shared/postgres_data_new' to '/shared/postgres_data/postgres_data_new': Directory not empty
I, [2020-05-16T20:14:34.359859 #1]  INFO -- : Upgrading PostgreSQL from version 10 to 12
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /shared/postgres_data_new ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok


Success. You can now start the database server using:

    /usr/lib/postgresql/12/bin/pg_ctl -D /shared/postgres_data_new -l logfile start

Get:1 http://security.debian.org/debian-security buster/updates InRelease [65.4 kB]
Hit:2 http://deb.debian.org/debian buster InRelease
Get:3 http://deb.debian.org/debian buster-updates InRelease [49.3 kB]
Get:4 http://apt.postgresql.org/pub/repos/apt buster-pgdg InRelease [84.4 kB]
Hit:5 https://deb.nodesource.com/node_10.x buster InRelease
Get:6 http://security.debian.org/debian-security buster/updates/main amd64 Packages [198 kB]
Get:7 http://apt.postgresql.org/pub/repos/apt buster-pgdg/main amd64 Packages [170 kB]
Fetched 567 kB in 1s (549 kB/s)
Reading package lists...
Reading package lists...
Building dependency tree...
Reading state information...
The following additional packages will be installed:
  postgresql-client-10
Suggested packages:
  postgresql-doc-10
The following NEW packages will be installed:
  postgresql-10 postgresql-client-10
0 upgraded, 2 newly installed, 0 to remove and 9 not upgraded.
Need to get 6,390 kB of archives.
After this operation, 30.6 MB of additional disk space will be used.
Get:1 http://apt.postgresql.org/pub/repos/apt buster-pgdg/main amd64 postgresql-client-10 amd64 10.13-1.pgdg100+1 [1,428 kB]
Get:2 http://apt.postgresql.org/pub/repos/apt buster-pgdg/main amd64 postgresql-10 amd64 10.13-1.pgdg100+1 [4,961 kB]
Fetched 6,390 kB in 0s (23.6 MB/s)
Selecting previously unselected package postgresql-client-10.
(Reading database ... 43929 files and directories currently installed.)
Preparing to unpack .../postgresql-client-10_10.13-1.pgdg100+1_amd64.deb ...
Unpacking postgresql-client-10 (10.13-1.pgdg100+1) ...
Selecting previously unselected package postgresql-10.
Preparing to unpack .../postgresql-10_10.13-1.pgdg100+1_amd64.deb ...
Unpacking postgresql-10 (10.13-1.pgdg100+1) ...
Setting up postgresql-client-10 (10.13-1.pgdg100+1) ...
update-alternatives: warning: forcing reinstallation of alternative /usr/share/postgresql/12/man/man1/psql.1.gz because link group psql.1.gz is broken
Setting up postgresql-10 (10.13-1.pgdg100+1) ...
Creating new PostgreSQL cluster 10/main ...
/usr/lib/postgresql/10/bin/initdb -D /var/lib/postgresql/10/main --auth-local peer --auth-host md5
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "C.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/postgresql/10/main ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default timezone ... Etc/UTC
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

Success. You can now start the database server using:

    pg_ctlcluster 10 main start

Warning: The selected stats_temp_directory /var/run/postgresql/10-main.pg_stat_tmp
is not writable for the cluster owner. Not adding this setting in
postgresql.conf.
Ver Cluster Port Status Owner    Data directory              Log file
10  main    5433 down   postgres /var/lib/postgresql/10/main /var/log/postgresql/postgresql-10-main.log
update-alternatives: warning: forcing reinstallation of alternative /usr/share/postgresql/12/man/man1/postmaster.1.gz because link group postmaster.1.gz is broken
invoke-rc.d: could not determine current runlevel
invoke-rc.d: policy-rc.d denied execution of start.
Processing triggers for postgresql-common (213.pgdg100+1) ...
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
Stopping PostgreSQL 10 database server: main.
Stopping PostgreSQL 12 database server: main.
Performing Consistency Checks
-----------------------------
Checking cluster versions                                   ok
Checking database user is the install user                  ok
Checking database connection settings                       ok
Checking for prepared transactions                          ok
Checking for reg* data types in user tables                 ok
Checking for contrib/isn with bigint-passing mismatch       ok
Checking for tables WITH OIDS                               ok
Checking for invalid "sql_identifier" user columns          ok
Creating dump of global objects                             ok
Creating dump of database schemas
  discourse
  postgres
  template1
                                                            ok
Checking for presence of required libraries                 ok
Checking database user is the install user                  ok
Checking for prepared transactions                          ok

If pg_upgrade fails after this point, you must re-initdb the
new cluster before continuing.

업그레이드 실행 중
------------------
새 클러스터의 모든 행 분석 중                       완료
새 클러스터의 모든 행 고정 중                        완료
새 pg_xact에서 파일 삭제 중                             완료
구 pg_xact를 새 서버로 복사 중                           완료
새 클러스터의 다음 트랜잭션 ID 및 에포크 설정 중       완료
새 pg_multixact/offsets에서 파일 삭제 중                완료
구 pg_multixact/offsets를 새 서버로 복사 중              완료
새 pg_multixact/members에서 파일 삭제 중                완료
구 pg_multixact/members를 새 서버로 복사 중              완료
새 클러스터의 다음 멀티트랜잭션 ID 및 오프셋 설정 중        완료
WAL 아카이브 재설정 중                                      완료
새 클러스터의 frozenxid 및 minmxid 카운터 설정 중       완료
새 클러스터의 전역 객체 복원 중                 완료
새 클러스터의 데이터베이스 스키마 복원 중
  template1
  discourse
  postgres
                                                            완료
사용자 관계 파일 복사 중
  /shared/postgres_data/base/16400/2613
  /shared/postgres_data/base/16400/2683
  /shared/postgres_data/base/16400/16728
  /shared/postgres_data/base/16400/16728_fsm
  /shared/postgres_data/base/16400/16728_vm
  /shared/postgres_data/base/16400/16731
  /shared/postgres_data/base/16400/16733
  /shared/postgres_data/base/16400/16734
  /shared/postgres_data/base/16400/16737
  /shared/postgres_data/base/16400/16737_fsm
  /shared/postgres_data/base/16400/16737_vm
  /shared/postgres_data/base/16400/16741
  /shared/postgres_data/base/16400/16743
  /shared/postgres_data/base/16400/16744
  /shared/postgres_data/base/16400/16746
  /shared/postgres_data/base/16400/49337
  /shared/postgres_data/base/16400/49337_fsm
  /shared/postgres_data/base/16400/49337_vm
  /shared/postgres_data/base/16400/49343
  /shared/postgres_data/base/16400/16760
  /shared/postgres_data/base/16400/16760_fsm
  /shared/postgres_data/base/16400/16760_vm
  /shared/postgres_data/base/16400/16767
  /shared/postgres_data/base/16400/35539
  /shared/postgres_data/base/16400/35539_fsm
  /shared/postgres_data/base/16400/35539_vm
  /shared/postgres_data/base/16400/35545
  /shared/postgres_data/base/16400/16797
  /shared/postgres_data/base/16400/16903
  /shared/postgres_data/base/16400/16903_fsm
  /shared/postgres_data/base/16400/16903_vm
  /shared/postgres_data/base/16400/58191
  /shared/postgres_data/base/16400/58191_fsm
  /shared/postgres_data/base/16400/58191_vm
  /shared/postgres_data/base/16400/58197
  /shared/postgres_data/base/16400/58198
  /shared/postgres_data/base/16400/16933
  /shared/postgres_data/base/16400/16933_fsm
  /shared/postgres_data/base/16400/16933_vm
  /shared/postgres_data/base/16400/16939
  /shared/postgres_data/base/16400/16943
  /shared/postgres_data/base/16400/16943_fsm
  /shared/postgres_data/base/16400/16943_vm
  /shared/postgres_data/base/16400/16951
  /shared/postgres_data/base/16400/16953
  /shared/postgres_data/base/16400/16976
  /shared/postgres_data/base/16400/16976_fsm
  /shared/postgres_data/base/16400/16976_vm
  /shared/postgres_data/base/16400/16986
  /shared/postgres_data/base/16400/16990
  /shared/postgres_data/base/16400/16992
  /shared/postgres_data/base/16400/16993
  /shared/postgres_data/base/16400/16996
  /shared/postgres_data/base/16400/16997
  /shared/postgres_data/base/16400/17009
  /shared/postgres_data/base/16400/17009_fsm
  /shared/postgres_data/base/16400/17009_vm
  /shared/postgres_data/base/16400/17017
  /shared/postgres_data/base/16400/17148
  /shared/postgres_data/base/16400/17148_fsm
  /shared/postgres_data/base/16400/17152
  /shared/postgres_data/base/16400/17154
  /shared/postgres_data/base/16400/17155
  /shared/postgres_data/base/16400/17158
  /shared/postgres_data/base/16400/17158_fsm
  /shared/postgres_data/base/16400/17158_vm
  /shared/postgres_data/base/16400/35546
  /shared/postgres_data/base/16400/57420
  /shared/postgres_data/base/16400/57420_fsm
  /shared/postgres_data/base/16400/57420_vm
  /shared/postgres_data/base/16400/57426
  /shared/postgres_data/base/16400/57427
  /shared/postgres_data/base/16400/17244
  /shared/postgres_data/base/16400/17244_fsm
  /shared/postgres_data/base/16400/17244_vm
  /shared/postgres_data/base/16400/17247
  /shared/postgres_data/base/16400/17250
  /shared/postgres_data/base/16400/17250_fsm
  /shared/postgres_data/base/16400/17250_vm
  /shared/postgres_data/base/16400/17254
  /shared/postgres_data/base/16400/17256
  /shared/postgres_data/base/16400/17257
  /shared/postgres_data/base/16400/17261
  /shared/postgres_data/base/16400/17265
  /shared/postgres_data/base/16400/17267
  /shared/postgres_data/base/16400/17268
  /shared/postgres_data/base/16400/17275
  /shared/postgres_data/base/16400/17327
  /shared/postgres_data/base/16400/17327_fsm
  /shared/postgres_data/base/16400/17327_vm
  /shared/postgres_data/base/16400/17331
  /shared/postgres_data/base/16400/17333
  /shared/postgres_data/base/16400/17334
  /shared/postgres_data/base/16400/17342
  /shared/postgres_data/base/16400/17342_fsm
  /shared/postgres_data/base/16400/17342_vm
  /shared/postgres_data/base/16400/17346
  /shared/postgres_data/base/16400/17348
  /shared/postgres_data/base/16400/51990
  /shared/postgres_data/base/16400/17359
  /shared/postgres_data/base/16400/17359_fsm
  /shared/postgres_data/base/16400/17359_vm
  /shared/postgres_data/base/16400/17363
  /shared/postgres_data/base/16400/17374
  /shared/postgres_data/base/16400/17375
  /shared/postgres_data/base/16400/17396
  /shared/postgres_data/base/16400/49344
  /shared/postgres_data/base/16400/51993
  /shared/postgres_data/base/16400/35737
  /shared/postgres_data/base/16400/35737_fsm
  /shared/postgres_data/base/16400/35737_vm
  /shared/postgres_data/base/16400/35743
  /shared/postgres_data/base/16400/35743_fsm
  /shared/postgres_data/base/16400/17584
  /shared/postgres_data/base/16400/17584_fsm
  /shared/postgres_data/base/16400/17584_vm
  /shared/postgres_data/base/16400/17588
  /shared/postgres_data/base/16400/17590
  /shared/postgres_data/base/16400/17591
  /shared/postgres_data/base/16400/17592
  /shared/postgres_data/base/16400/43439
  /shared/postgres_data/base/16400/43445
  /shared/postgres_data/base/16400/43446
  /shared/postgres_data/base/16400/17716
  /shared/postgres_data/base/16400/17720
  /shared/postgres_data/base/16400/17722
  /shared/postgres_data/base/16400/17723
  /shared/postgres_data/base/16400/35555
  /shared/postgres_data/base/16400/35555_fsm
  /shared/postgres_data/base/16400/35555_vm
  /shared/postgres_data/base/16400/35558
  /shared/postgres_data/base/16400/35559
  /shared/postgres_data/base/16400/17736
  /shared/postgres_data/base/16400/17736_fsm
  /shared/postgres_data/base/16400/17736_vm
  /shared/postgres_data/base/16400/17742
  /shared/postgres_data/base/16400/17744
  /shared/postgres_data/base/16400/17745
  /shared/postgres_data/base/16400/17747
  /shared/postgres_data/base/16400/17750
  /shared/postgres_data/base/16400/17750_fsm
  /shared/postgres_data/base/16400/17750_vm
  /shared/postgres_data/base/16400/17757
  /shared/postgres_data/base/16400/54084
  /shared/postgres_data/base/16400/54090
  /shared/postgres_data/base/16400/17839
  /shared/postgres_data/base/16400/17839_fsm
  /shared/postgres_data/base/16400/17839_vm
  /shared/postgres_data/base/16400/17843
  /shared/postgres_data/base/16400/17845
  /shared/postgres_data/base/16400/17846
  /shared/postgres_data/base/16400/17848
  /shared/postgres_data/base/16400/17874
  /shared/postgres_data/base/16400/17874_fsm
  /shared/postgres_data/base/16400/17874_vm
  /shared/postgres_data/base/16400/17880
  /shared/postgres_data/base/16400/17882
  /shared/postgres_data/base/16400/17882_fsm
  /shared/postgres_data/base/16400/17882_vm
  /shared/postgres_data/base/16400/17888
  /shared/postgres_data/base/16400/17890
  /shared/postgres_data/base/16400/17890_fsm
  /shared/postgres_data/base/16400/17890_vm
  /shared/postgres_data/base/16400/17896
  /shared/postgres_data/base/16400/17898
  /shared/postgres_data/base/16400/17898_fsm
  /shared/postgres_data/base/16400/17899
  /shared/postgres_data/base/16400/17899_fsm
  /shared/postgres_data/base/16400/17900
  /shared/postgres_data/base/16400/17900_fsm
  /shared/postgres_data/base/16400/18093
  /shared/postgres_data/base/16400/18097
  /shared/postgres_data/base/16400/18099
  /shared/postgres_data/base/16400/18100
  /shared/postgres_data/base/16400/18102
  /shared/postgres_data/base/16400/18103
  /shared/postgres_data/base/16400/18244
  /shared/postgres_data/base/16400/18244_fsm
  /shared/postgres_data/base/16400/18244_vm
  /shared/postgres_data/base/16400/18251
  /shared/postgres_data/base/16400/55628
  /shared/postgres_data/base/16400/55634
  /shared/postgres_data/base/16400/18287
  /shared/postgres_data/base/16400/18287_fsm
  /shared/postgres_data/base/16400/18287_vm
  /shared/postgres_data/base/16400/18291
  /shared/postgres_data/base/16400/18293
  /shared/postgres_data/base/16400/18297
  /shared/postgres_data/base/16400/18299
  /shared/postgres_data/base/16400/18315
  /shared/postgres_data/base/16400/18315_fsm
  /shared/postgres_data/base/16400/18315_vm
  /shared/postgres_data/base/16400/18319
  /shared/postgres_data/base/16400/18323
  /shared/postgres_data/base/16400/18323_fsm
  /shared/postgres_data/base/16400/18323_vm
  /shared/postgres_data/base/16400/18327
  /shared/postgres_data/base/16400/18329
  /shared/postgres_data/base/16400/18330
  /shared/postgres_data/base/16400/55635
  /shared/postgres_data/base/16400/18377
  /shared/postgres_data/base/16400/18410
  /shared/postgres_data/base/16400/18410_fsm
  /shared/postgres_data/base/16400/18410_vm
  /shared/postgres_data/base/16400/18414
  /shared/postgres_data/base/16400/18416
  /shared/postgres_data/base/16400/18433
  /shared/postgres_data/base/16400/18433_fsm
  /shared/postgres_data/base/16400/18433_vm
  /shared/postgres_data/base/16400/18440
  /shared/postgres_data/base/16400/18442
  /shared/postgres_data/base/16400/18443
  /shared/postgres_data/base/16400/58199
  /shared/postgres_data/base/16400/58200
  /shared/postgres_data/base/16400/18469
  /shared/postgres_data/base/16400/18471
  /shared/postgres_data/base/16400/18472
  /shared/postgres_data/base/16400/18474
  /shared/postgres_data/base/16400/18494
  /shared/postgres_data/base/16400/18505
  /shared/postgres_data/base/16400/18514
  /shared/postgres_data/base/16400/18519
  /shared/postgres_data/base/16400/18521
  /shared/postgres_data/base/16400/18522
  /shared/postgres_data/base/16400/18524
  /shared/postgres_data/base/16400/18525
  /shared/postgres_data/base/16400/18527
  /shared/postgres_data/base/16400/18530
  /shared/postgres_data/base/16400/18531
  /shared/postgres_data/base/16400/18533
  /shared/postgres_data/base/16400/18549
  /shared/postgres_data/base/16400/18554
  /shared/postgres_data/base/16400/18556
  /shared/postgres_data/base/16400/18557
  /shared/postgres_data/base/16400/18559
  /shared/postgres_data/base/16400/18560
  /shared/postgres_data/base/16400/18563
  /shared/postgres_data/base/16400/18567
  /shared/postgres_data/base/16400/18569
  /shared/postgres_data/base/16400/18570
  /shared/postgres_data/base/16400/18572
  /shared/postgres_data/base/16400/18573
  /shared/postgres_data/base/16400/18577
  /shared/postgres_data/base/16400/18577_fsm
  /shared/postgres_data/base/16400/18581
  /shared/postgres_data/base/16400/18583
  /shared/postgres_data/base/16400/18584
  /shared/postgres_data/base/16400/18586
  /shared/postgres_data/base/16400/18587
  /shared/postgres_data/base/16400/49345
  /shared/postgres_data/base/16400/58201
  /shared/postgres_data/base/16400/49346
  /shared/postgres_data/base/16400/60531
  /shared/postgres_data/base/16400/60531_fsm
  /shared/postgres_data/base/16400/60531_vm
  /shared/postgres_data/base/16400/60534
  /shared/postgres_data/base/16400/18599
  /shared/postgres_data/base/16400/18654
  /shared/postgres_data/base/16400/18658
  /shared/postgres_data/base/16400/18660
  /shared/postgres_data/base/16400/18661
  /shared/postgres_data/base/16400/18663
  /shared/postgres_data/base/16400/18676
  /shared/postgres_data/base/16400/18676_fsm
  /shared/postgres_data/base/16400/18676_vm
  /shared/postgres_data/base/16400/18681
  /shared/postgres_data/base/16400/18683
  /shared/postgres_data/base/16400/18684
  /shared/postgres_data/base/16400/18686
  /shared/postgres_data/base/16400/18687
  /shared/postgres_data/base/16400/18691
  /shared/postgres_data/base/16400/18695
  /shared/postgres_data/base/16400/18723
  /shared/postgres_data/base/16400/18723_fsm
  /shared/postgres_data/base/16400/18723_vm
  /shared/postgres_data/base/16400/18730
  /shared/postgres_data/base/16400/18732
  /shared/postgres_data/base/16400/18733
  /shared/postgres_data/base/16400/18760
  /shared/postgres_data/base/16400/18767
  /shared/postgres_data/base/16400/18783
  /shared/postgres_data/base/16400/18783_fsm
  /shared/postgres_data/base/16400/18783_vm
  /shared/postgres_data/base/16400/18799
  /shared/postgres_data/base/16400/18801
  /shared/postgres_data/base/16400/18802
  /shared/postgres_data/base/16400/18802_fsm
  /shared/postgres_data/base/16400/18803
  /shared/postgres_data/base/16400/18803_fsm
  /shared/postgres_data/base/16400/18804
  /shared/postgres_data/base/16400/18804_fsm
  /shared/postgres_data/base/16400/18805
  /shared/postgres_data/base/16400/18805_fsm
  /shared/postgres_data/base/16400/18806
  /shared/postgres_data/base/16400/18806_fsm
  /shared/postgres_data/base/16400/18807
  /shared/postgres_data/base/16400/18807_fsm
  /shared/postgres_data/base/16400/18808
  /shared/postgres_data/base/16400/18808_fsm
  /shared/postgres_data/base/16400/18809
  /shared/postgres_data/base/16400/18809_fsm
  /shared/postgres_data/base/16400/18810
  /shared/postgres_data/base/16400/18810_fsm
  /shared/postgres_data/base/16400/18811
  /shared/postgres_data/base/16400/18811_fsm
  /shared/postgres_data/base/16400/18812
  /shared/postgres_data/base/16400/18812_fsm
  /shared/postgres_data/base/16400/18813
  /shared/postgres_data/base/16400/18813_fsm
  /shared/postgres_data/base/16400/18829
  /shared/postgres_data/base/16400/18829_fsm
  /shared/postgres_data/base/16400/18829_vm
  /shared/postgres_data/base/16400/18833
  /shared/postgres_data/base/16400/18860
  /shared/postgres_data/base/16400/18862
  /shared/postgres_data/base/16400/18880
  /shared/postgres_data/base/16400/18887
  /shared/postgres_data/base/16400/18889
  /shared/postgres_data/base/16400/57428
  /shared/postgres_data/base/16400/18905
  /shared/postgres_data/base/16400/18905_fsm
  /shared/postgres_data/base/16400/18907
  /shared/postgres_data/base/16400/18915
  /shared/postgres_data/base/16400/18915_fsm
  /shared/postgres_data/base/16400/18915_vm
  /shared/postgres_data/base/16400/18919
  /shared/postgres_data/base/16400/18921
  /shared/postgres_data/base/16400/18922
  /shared/postgres_data/base/16400/18924
  /shared/postgres_data/base/16400/18927
  /shared/postgres_data/base/16400/18927_fsm
  /shared/postgres_data/base/16400/18927_vm
  /shared/postgres_data/base/16400/18935
  /shared/postgres_data/base/16400/18937
  /shared/postgres_data/base/16400/18938
  /shared/postgres_data/base/16400/18941
  /shared/postgres_data/base/16400/18941_fsm
  /shared/postgres_data/base/16400/18941_vm
  /shared/postgres_data/base/16400/18945
  /shared/postgres_data/base/16400/18947
  /shared/postgres_data/base/16400/49347
  /shared/postgres_data/base/16400/35547
  /shared/postgres_data/base/16400/35548
  /shared/postgres_data/base/16400/19005
  /shared/postgres_data/base/16400/19014
  /shared/postgres_data/base/16400/19018
  /shared/postgres_data/base/16400/19023
  /shared/postgres_data/base/16400/19025
  /shared/postgres_data/base/16400/19026
  /shared/postgres_data/base/16400/19028
  /shared/postgres_data/base/16400/19031
  /shared/postgres_data/base/16400/19031_fsm
  /shared/postgres_data/base/16400/19035
  /shared/postgres_data/base/16400/19037
  /shared/postgres_data/base/16400/19038
  /shared/postgres_data/base/16400/19040
  /shared/postgres_data/base/16400/19052
  /shared/postgres_data/base/16400/19056
  /shared/postgres_data/base/16400/19058
  /shared/postgres_data/base/16400/19059
  /shared/postgres_data/base/16400/19063
  /shared/postgres_data/base/16400/19067
  /shared/postgres_data/base/16400/19069
  /shared/postgres_data/base/16400/19070
  /shared/postgres_data/base/16400/19074
  /shared/postgres_data/base/16400/19074_fsm
  /shared/postgres_data/base/16400/19078
  /shared/postgres_data/base/16400/19080
  /shared/postgres_data/base/16400/19081
  /shared/postgres_data/base/16400/19083
  /shared/postgres_data/base/16400/19084
  /shared/postgres_data/base/16400/19085
  /shared/postgres_data/base/16400/19088
  /shared/postgres_data/base/16400/19092
  /shared/postgres_data/base/16400/19094
  /shared/postgres_data/base/16400/19095
  /shared/postgres_data/base/16400/19097
  /shared/postgres_data/base/16400/19110
  /shared/postgres_data/base/16400/19114
  /shared/postgres_data/base/16400/19126
  /shared/postgres_data/base/16400/19142
  /shared/postgres_data/base/16400/19142_fsm
  /shared/postgres_data/base/16400/19142_vm
  /shared/postgres_data/base/16400/19146
  /shared/postgres_data/base/16400/19148
  /shared/postgres_data/base/16400/19163
  /shared/postgres_data/base/16400/19163_fsm
  /shared/postgres_data/base/16400/19163_vm
  /shared/postgres_data/base/16400/19169
  /shared/postgres_data/base/16400/19187
  /shared/postgres_data/base/16400/57429
  /shared/postgres_data/base/16400/19209
  /shared/postgres_data/base/16400/19242
  /shared/postgres_data/base/16400/19244
  /shared/postgres_data/base/16400/19264
  /shared/postgres_data/base/16400/19277
  /shared/postgres_data/base/16400/19281
  /shared/postgres_data/base/16400/19283
  /shared/postgres_data/base/16400/19284
  /shared/postgres_data/base/16400/19288
  /shared/postgres_data/base/16400/19288_fsm
  /shared/postgres_data/base/16400/19288_vm
  /shared/postgres_data/base/16400/19292
  /shared/postgres_data/base/16400/19294
  /shared/postgres_data/base/16400/19295
  /shared/postgres_data/base/16400/43447
  /shared/postgres_data/base/16400/19345
  /shared/postgres_data/base/16400/19346
  /shared/postgres_data/base/16400/19349
  /shared/postgres_data/base/16400/19349_fsm
  /shared/postgres_data/base/16400/19353
  /shared/postgres_data/base/16400/19355
  /shared/postgres_data/base/16400/19356
  /shared/postgres_data/base/16400/19360
  /shared/postgres_data/base/16400/19360_fsm
  /shared/postgres_data/base/16400/19365
  /shared/postgres_data/base/16400/19367
  /shared/postgres_data/base/16400/19368
  /shared/postgres_data/base/16400/19390
  /shared/postgres_data/base/16400/19391
  /shared/postgres_data/base/16400/19392
  /shared/postgres_data/base/16400/19397
  /shared/postgres_data/base/16400/19399
  /shared/postgres_data/base/16400/35549
  /shared/postgres_data/base/16400/19404
  /shared/postgres_data/base/16400/19404_fsm
  /shared/postgres_data/base/16400/19404_vm
  /shared/postgres_data/base/16400/19410
  /shared/postgres_data/base/16400/19412
  /shared/postgres_data/base/16400/19412_fsm
  /shared/postgres_data/base/16400/19421
  /shared/postgres_data/base/16400/19427
  /shared/postgres_data/base/16400/19428
  /shared/postgres_data/base/16400/19430
  /shared/postgres_data/base/16400/19431
  /shared/postgres_data/base/16400/19432
  /shared/postgres_data/base/16400/19433
  /shared/postgres_data/base/16400/35746
  /shared/postgres_data/base/16400/35746_fsm
  /shared/postgres_data/base/16400/19444
  /shared/postgres_data/base/16400/19444_fsm
  /shared/postgres_data/base/16400/19444_vm
  /shared/postgres_data/base/16400/19451
  /shared/postgres_data/base/16400/19457
  /shared/postgres_data/base/16400/19459
  /shared/postgres_data/base/16400/19461
  /shared/postgres_data/base/16400/19462
  /shared/postgres_data/base/16400/19477
  /shared/postgres_data/base/16400/19481
  /shared/postgres_data/base/16400/19483
  /shared/postgres_data/base/16400/19484
  /shared/postgres_data/base/16400/19485
  /shared/postgres_data/base/16400/19503
  /shared/postgres_data/base/16400/19510
  /shared/postgres_data/base/16400/19564
  /shared/postgres_data/base/16400/19564_fsm
  /shared/postgres_data/base/16400/19564_vm
  /shared/postgres_data/base/16400/19566
  /shared/postgres_data/base/16400/19574
  /shared/postgres_data/base/16400/19574_fsm
  /shared/postgres_data/base/16400/19574_vm
  /shared/postgres_data/base/16400/19576
  /shared/postgres_data/base/16400/19589
  /shared/postgres_data/base/16400/19591
  /shared/postgres_data/base/16400/19597
  /shared/postgres_data/base/16400/19601
  /shared/postgres_data/base/16400/19603
  /shared/postgres_data/base/16400/19604
  /shared/postgres_data/base/16400/19630
  /shared/postgres_data/base/16400/19650
  /shared/postgres_data/base/16400/19650_fsm
  /shared/postgres_data/base/16400/19650_vm
  /shared/postgres_data/base/16400/19655
  /shared/postgres_data/base/16400/19657
  /shared/postgres_data/base/16400/19664
  /shared/postgres_data/base/16400/19664_fsm
  /shared/postgres_data/base/16400/19664_vm
  /shared/postgres_data/base/16400/19667
  /shared/postgres_data/base/16400/19667_fsm
  /shared/postgres_data/base/16400/19669
  /shared/postgres_data/base/16400/19669_fsm
  /shared/postgres_data/base/16400/49348
  /shared/postgres_data/base/16400/49349
  /shared/postgres_data/base/16400/49350
  /shared/postgres_data/base/16400/19709
  /shared/postgres_data/base/16400/19709_fsm
  /shared/postgres_data/base/16400/19729
  /shared/postgres_data/base/16400/19729_fsm
  /shared/postgres_data/base/16400/19750
  /shared/postgres_data/base/16400/19750_fsm
  /shared/postgres_data/base/16400/19772
  /shared/postgres_data/base/16400/19772_fsm
  /shared/postgres_data/base/16400/19775
  /shared/postgres_data/base/16400/19775_fsm
  /shared/postgres_data/base/16400/19775_vm
  /shared/postgres_data/base/16400/19779
  /shared/postgres_data/base/16400/19793
  /shared/postgres_data/base/16400/19797
  /shared/postgres_data/base/16400/19799
  /shared/postgres_data/base/16400/19800
  /shared/postgres_data/base/16400/19838
  /shared/postgres_data/base/16400/19840
  /shared/postgres_data/base/16400/19842
  /shared/postgres_data/base/16400/19843
  /shared/postgres_data/base/16400/19846
  /shared/postgres_data/base/16400/19846_fsm
  /shared/postgres_data/base/16400/19846_vm
  /shared/postgres_data/base/16400/19853
  /shared/postgres_data/base/16400/19855
  /shared/postgres_data/base/16400/19856
  /shared/postgres_data/base/16400/19857
  /shared/postgres_data/base/16400/19858
  /shared/postgres_data/base/16400/19859
  /shared/postgres_data/base/16400/19860
  /shared/postgres_data/base/16400/35550
  /shared/postgres_data/base/16400/35551
  /shared/postgres_data/base/16400/35560
  /shared/postgres_data/base/16400/19874
  /shared/postgres_data/base/16400/19878
  /shared/postgres_data/base/16400/19880
  /shared/postgres_data/base/16400/19881
  /shared/postgres_data/base/16400/19993
  /shared/postgres_data/base/16400/19993_fsm
  /shared/postgres_data/base/16400/19994
  /shared/postgres_data/base/16400/19994_fsm
  /shared/postgres_data/base/16400/19995
  /shared/postgres_data/base/16400/19995_fsm
  /shared/postgres_data/base/16400/19996
  /shared/postgres_data/base/16400/19996_fsm
  /shared/postgres_data/base/16400/19997
  /shared/postgres_data/base/16400/20010
  /shared/postgres_data/base/16400/20010_fsm
  /shared/postgres_data/base/16400/20010_vm
  /shared/postgres_data/base/16400/20012
  /shared/postgres_data/base/16400/20017
  /shared/postgres_data/base/16400/20017_fsm
  /shared/postgres_data/base/16400/20017_vm
  /shared/postgres_data/base/16400/20021
  /shared/postgres_data/base/16400/20023
  /shared/postgres_data/base/16400/20026
  /shared/postgres_data/base/16400/20030
  /shared/postgres_data/base/16400/20032
  /shared/postgres_data/base/16400/20033
  /shared/postgres_data/base/16400/20048
  /shared/postgres_data/base/16400/20048_fsm
  /shared/postgres_data/base/16400/20048_vm
  /shared/postgres_data/base/16400/20052
  /shared/postgres_data/base/16400/20054
  /shared/postgres_data/base/16400/20055
  /shared/postgres_data/base/16400/20057
  /shared/postgres_data/base/16400/20058
  /shared/postgres_data/base/16400/20065
  /shared/postgres_data/base/16400/20067
  /shared/postgres_data/base/16400/20070
  /shared/postgres_data/base/16400/20071
  /shared/postgres_data/base/16400/49351
  /shared/postgres_data/base/16400/20103
  /shared/postgres_data/base/16400/20107
  /shared/postgres_data/base/16400/20109
  /shared/postgres_data/base/16400/20110
  /shared/postgres_data/base/16400/20112
  /shared/postgres_data/base/16400/20142
  /shared/postgres_data/base/16400/20146
  /shared/postgres_data/base/16400/20148
  /shared/postgres_data/base/16400/20149
  /shared/postgres_data/base/16400/55636
  /shared/postgres_data/base/16400/20172
  /shared/postgres_data/base/16400/20172_fsm
  /shared/postgres_data/base/16400/20172_vm
  /shared/postgres_data/base/16400/20176
  /shared/postgres_data/base/16400/20178
  /shared/postgres_data/base/16400/20181
  /shared/postgres_data/base/16400/20185
  /shared/postgres_data/base/16400/20187
  /shared/postgres_data/base/16400/20190
  /shared/postgres_data/base/16400/20197
  /shared/postgres_data/base/16400/20199
  /shared/postgres_data/base/16400/20200
  /shared/postgres_data/base/16400/20201
  /shared/postgres_data/base/16400/20204
  /shared/postgres_data/base/16400/52005
  /shared/postgres_data/base/16400/52011
  /shared/postgres_data/base/16400/20247
  /shared/postgres_data/base/16400/20255
  /shared/postgres_data/base/16400/20259
  /shared/postgres_data/base/16400/20261
  /shared/postgres_data/base/16400/20262
  /shared/postgres_data/base/16400/20264
  /shared/postgres_data/base/16400/20265
  /shared/postgres_data/base/16400/20265_fsm
  /shared/postgres_data/base/16400/20265_vm
  /shared/postgres_data/base/16400/20269
  /shared/postgres_data/base/16400/20270
  /shared/postgres_data/base/16400/20287
  /shared/postgres_data/base/16400/20287_fsm
  /shared/postgres_data/base/16400/20287_vm
  /shared/postgres_data/base/16400/20291
  /shared/postgres_data/base/16400/20293
  /shared/postgres_data/base/16400/20294
  /shared/postgres_data/base/16400/20296
  /shared/postgres_data/base/16400/20301
  /shared/postgres_data/base/16400/20303
  /shared/postgres_data/base/16400/20345
  /shared/postgres_data/base/16400/20362
  /shared/postgres_data/base/16400/20364
  /shared/postgres_data/base/16400/35687
  /shared/postgres_data/base/16400/35693
  /shared/postgres_data/base/16400/20389
  /shared/postgres_data/base/16400/20393
  /shared/postgres_data/base/16400/20397
  /shared/postgres_data/base/16400/20401
  /shared/postgres_data/base/16400/35694
  /shared/postgres_data/base/16400/20404
  /shared/postgres_data/base/16400/20405
  /shared/postgres_data/base/16400/20406
  /shared/postgres_data/base/16400/20407
  /shared/postgres_data/base/16400/20410
  /shared/postgres_data/base/16400/20414
  /shared/postgres_data/base/16400/20416
  /shared/postgres_data/base/16400/20417
  /shared/postgres_data/base/16400/20420
  /shared/postgres_data/base/16400/20420_fsm
  /shared/postgres_data/base/16400/20420_vm
  /shared/postgres_data/base/16400/20424
  /shared/postgres_data/base/16400/20426
  /shared/postgres_data/base/16400/20427
  /shared/postgres_data/base/16400/20427_fsm
  /shared/postgres_data/base/16400/35747
  /shared/postgres_data/base/16400/35747_fsm
  /shared/postgres_data/base/16400/20432
  /shared/postgres_data/base/16400/20440
  /shared/postgres_data/base/16400/20444
  /shared/postgres_data/base/16400/20448
  /shared/postgres_data/base/16400/20450
  /shared/postgres_data/base/16400/20453
  /shared/postgres_data/base/16400/20457
  /shared/postgres_data/base/16400/20459
  /shared/postgres_data/base/16400/20464
  /shared/postgres_data/base/16400/20466
  /shared/postgres_data/base/16400/20468
  /shared/postgres_data/base/16400/20470
  /shared/postgres_data/base/16400/28798
  /shared/postgres_data/base/16400/28801
  /shared/postgres_data/base/16400/28805
  /shared/postgres_data/base/16400/36898
  /shared/postgres_data/base/16400/36898_fsm
  /shared/postgres_data/base/16400/36898_vm
  /shared/postgres_data/base/16400/36904
  /shared/postgres_data/base/16400/36905
  /shared/postgres_data/base/16400/36906
  /shared/postgres_data/base/16400/36907
  /shared/postgres_data/base/16400/28824
  /shared/postgres_data/base/16400/28824_fsm
  /shared/postgres_data/base/16400/28824_vm
  /shared/postgres_data/base/16400/28828
  /shared/postgres_data/base/16400/28830
  /shared/postgres_data/base/16400/28831
  /shared/postgres_data/base/16400/28835
  /shared/postgres_data/base/16400/28846
  /shared/postgres_data/base/16400/28848
  /shared/postgres_data/base/16400/28849
  /shared/postgres_data/base/16400/28853
  /shared/postgres_data/base/16400/28859
  /shared/postgres_data/base/16400/28861
  /shared/postgres_data/base/16400/28862
  /shared/postgres_data/base/16400/28864
  /shared/postgres_data/base/16400/28865
  /shared/postgres_data/base/16400/28868
  /shared/postgres_data/base/16400/28869
  /shared/postgres_data/base/16400/28872
  /shared/postgres_data/base/16400/28873
  /shared/postgres_data/base/16400/28876
  /shared/postgres_data/base/16400/28881
  /shared/postgres_data/base/16400/28883
  /shared/postgres_data/base/16400/28898
  /shared/postgres_data/base/16400/28900
  /shared/postgres_data/base/16400/28914
  /shared/postgres_data/base/16400/28915
  /shared/postgres_data/base/16400/28916
  /shared/postgres_data/base/16400/28917
  /shared/postgres_data/base/16400/28918
  /shared/postgres_data/base/16400/28919
  /shared/postgres_data/base/16400/28920
  /shared/postgres_data/base/16400/28921
  /shared/postgres_data/base/16400/28922
  /shared/postgres_data/base/16400/35553
  /shared/postgres_data/base/16400/28924
  /shared/postgres_data/base/16400/28925
  /shared/postgres_data/base/16400/28930
  /shared/postgres_data/base/16400/28930_fsm
  /shared/postgres_data/base/16400/28931
  /shared/postgres_data/base/16400/28931_fsm
  /shared/postgres_data/base/16400/28932
  /shared/postgres_data/base/16400/28932_fsm
  /shared/postgres_data/base/16400/28933
  /shared/postgres_data/base/16400/28933_fsm
  /shared/postgres_data/base/16400/28934
  /shared/postgres_data/base/16400/28963
  /shared/postgres_data/base/16400/28967
  /shared/postgres_data/base/16400/28969
  /shared/postgres_data/base/16400/28970
  /shared/postgres_data/base/16400/28972
  /shared/postgres_data/base/16400/28973
  /shared/postgres_data/base/16400/28974
  /shared/postgres_data/base/16400/28975
  /shared/postgres_data/base/16400/29092
  /shared/postgres_data/base/16400/29092_fsm
  /shared/postgres_data/base/16400/29092_vm
  /shared/postgres_data/base/16400/29098
  /shared/postgres_data/base/16400/29100
  /shared/postgres_data/base/16400/29101
  /shared/postgres_data/base/16400/29107
  /shared/postgres_data/base/16400/29111
  /shared/postgres_data/base/16400/29113
  /shared/postgres_data/base/16400/29114
  /shared/postgres_data/base/16400/29116
  /shared/postgres_data/base/16400/29119
  /shared/postgres_data/base/16400/29119_fsm
  /shared/postgres_data/base/16400/29119_vm
  /shared/postgres_data/base/16400/29123
  /shared/postgres_data/base/16400/29125
  /shared/postgres_data/base/16400/29126
  /shared/postgres_data/base/16400/29126_fsm
  /shared/postgres_data/base/16400/29139
  /shared/postgres_data/base/16400/29140
  /shared/postgres_data/base/16400/29152
  /shared/postgres_data/base/16400/29184
  /shared/postgres_data/base/16400/29188
  /shared/postgres_data/base/16400/29190
  /shared/postgres_data/base/16400/29191
  /shared/postgres_data/base/16400/29194
  /shared/postgres_data/base/16400/29199
  /shared/postgres_data/base/16400/29201
  /shared/postgres_data/base/16400/29206
  /shared/postgres_data/base/16400/29206_fsm
  /shared/postgres_data/base/16400/29206_vm
  /shared/postgres_data/base/16400/29208
  /shared/postgres_data/base/16400/29208_fsm
  /shared/postgres_data/base/16400/52013
  /shared/postgres_data/base/16400/52019
  /shared/postgres_data/base/16400/29260
  /shared/postgres_data/base/16400/29264
  /shared/postgres_data/base/16400/29266
  /shared/postgres_data/base/16400/29267
  /shared/postgres_data/base/16400/54091
  /shared/postgres_data/base/16400/29421
  /shared/postgres_data/base/16400/29815
  /shared/postgres_data/base/16400/29818
  /shared/postgres_data/base/16400/29820
  /shared/postgres_data/base/16400/29821
  /shared/postgres_data/base/16400/29823
  /shared/postgres_data/base/16400/29826
  /shared/postgres_data/base/16400/29830
  /shared/postgres_data/base/16400/29832
  /shared/postgres_data/base/16400/29833
  /shared/postgres_data/base/16400/29835
  /shared/postgres_data/base/16400/58202
  /shared/postgres_data/base/16400/29839
  /shared/postgres_data/base/16400/29839_fsm
  /shared/postgres_data/base/16400/29839_vm
  /shared/postgres_data/base/16400/29843
  /shared/postgres_data/base/16400/29845
  /shared/postgres_data/base/16400/29846
  /shared/postgres_data/base/16400/29850
  /shared/postgres_data/base/16400/29850_fsm
  /shared/postgres_data/base/16400/29855
  /shared/postgres_data/base/16400/29857
  /shared/postgres_data/base/16400/29858
  /shared/postgres_data/base/16400/29860
  /shared/postgres_data/base/16400/29862
  /shared/postgres_data/base/16400/29889
  /shared/postgres_data/base/16400/29889_fsm
  /shared/postgres_data/base/16400/29889_vm
  /shared/postgres_data/base/16400/29891
  /shared/postgres_data/base/16400/29891_fsm
  /shared/postgres_data/base/16400/29976
  /shared/postgres_data/base/16400/29978
  /shared/postgres_data/base/16400/29985
  /shared/postgres_data/base/16400/29987
  /shared/postgres_data/base/16400/29994
  /shared/postgres_data/base/16400/29996
  /shared/postgres_data/base/16400/30021
  /shared/postgres_data/base/16400/30026
  /shared/postgres_data/base/16400/30028
  /shared/postgres_data/base/16400/30029
  /shared/postgres_data/base/16400/30031
  /shared/postgres_data/base/16400/49352
  /shared/postgres_data/base/16400/35542
  /shared/postgres_data/base/16400/35544
  /shared/postgres_data/base/16400/35561
  /shared/postgres_data/base/16400/35573
  /shared/postgres_data/base/16400/35576
  /shared/postgres_data/base/16400/35581
  /shared/postgres_data/base/16400/35583
  /shared/postgres_data/base/16400/35584
  /shared/postgres_data/base/16400/35748
  /shared/postgres_data/base/16400/35748_fsm
  /shared/postgres_data/base/16400/35590
  /shared/postgres_data/base/16400/35594
  /shared/postgres_data/base/16400/35596
  /shared/postgres_data/base/16400/35597
  /shared/postgres_data/base/16400/35602
  /shared/postgres_data/base/16400/35607
  /shared/postgres_data/base/16400/35609
  /shared/postgres_data/base/16400/35610
  /shared/postgres_data/base/16400/35611
  /shared/postgres_data/base/16400/35612
  /shared/postgres_data/base/16400/35657
  /shared/postgres_data/base/16400/35660
  /shared/postgres_data/base/16400/35630
  /shared/postgres_data/base/16400/35630_fsm
  /shared/postgres_data/base/16400/35630_vm
  /shared/postgres_data/base/16400/35635
  /shared/postgres_data/base/16400/35637
  /shared/postgres_data/base/16400/35638
  /shared/postgres_data/base/16400/35638_fsm
  /shared/postgres_data/base/16400/35640
  /shared/postgres_data/base/16400/35640_fsm
  /shared/postgres_data/base/16400/35643
  /shared/postgres_data/base/16400/35648
  /shared/postgres_data/base/16400/35650
  /shared/postgres_data/base/16400/35651
  /shared/postgres_data/base/16400/35661
  /shared/postgres_data/base/16400/35662
  /shared/postgres_data/base/16400/35663
  /shared/postgres_data/base/16400/35677
  /shared/postgres_data/base/16400/35681
  /shared/postgres_data/base/16400/35683
  /shared/postgres_data/base/16400/35684
  /shared/postgres_data/base/16400/35690
  /shared/postgres_data/base/16400/35692
  /shared/postgres_data/base/16400/35696
  /shared/postgres_data/base/16400/35697
  /shared/postgres_data/base/16400/35706
  /shared/postgres_data/base/16400/35707
  /shared/postgres_data/base/16400/35734
  /shared/postgres_data/base/16400/35740
  /shared/postgres_data/base/16400/35742
  /shared/postgres_data/base/16400/35754
  /shared/postgres_data/base/16400/35758
  /shared/postgres_data/base/16400/35760
  /shared/postgres_data/base/16400/35763
  /shared/postgres_data/base/16400/35764
  /shared/postgres_data/base/16400/35764_fsm
  /shared/postgres_data/base/16400/35768
  /shared/postgres_data/base/16400/35768_fsm
  /shared/postgres_data/base/16400/35768_vm
  /shared/postgres_data/base/16400/35772
  /shared/postgres_data/base/16400/35774
  /shared/postgres_data/base/16400/35775
  /shared/postgres_data/base/16400/35777
  /shared/postgres_data/base/16400/35778
  /shared/postgres_data/base/16400/35779
  /shared/postgres_data/base/16400/35780
  /shared/postgres_data/base/16400/35784
  /shared/postgres_data/base/16400/35784_fsm
  /shared/postgres_data/base/16400/36901
  /shared/postgres_data/base/16400/36903
  /shared/postgres_data/base/16400/38877
  /shared/postgres_data/base/16400/38877_fsm
  /shared/postgres_data/base/16400/38881
  /shared/postgres_data/base/16400/38883
  /shared/postgres_data/base/16400/58213
  /shared/postgres_data/base/16400/58219
  /shared/postgres_data/base/16400/58220
  /shared/postgres_data/base/16400/58221
  /shared/postgres_data/base/16400/42503
  /shared/postgres_data/base/16400/42507
  /shared/postgres_data/base/16400/42509
  /shared/postgres_data/base/16400/42510
  /shared/postgres_data/base/16400/42517
  /shared/postgres_data/base/16400/42518
  /shared/postgres_data/base/16400/42519
  /shared/postgres_data/base/16400/42537
  /shared/postgres_data/base/16400/42538
  /shared/postgres_data/base/16400/42539
  /shared/postgres_data/base/16400/42540
  /shared/postgres_data/base/16400/42548
  /shared/postgres_data/base/16400/42552
  /shared/postgres_data/base/16400/42554
  /shared/postgres_data/base/16400/42555
  /shared/postgres_data/base/16400/42557
  /shared/postgres_data/base/16400/42558
  /shared/postgres_data/base/16400/42559
  /shared/postgres_data/base/16400/42585
  /shared/postgres_data/base/16400/42585_fsm
  /shared/postgres_data/base/16400/42593
  /shared/postgres_data/base/16400/42595
  /shared/postgres_data/base/16400/42596
  /shared/postgres_data/base/16400/42598
  /shared/postgres_data/base/16400/42599
  /shared/postgres_data/base/16400/43442
  /shared/postgres_data/base/16400/43444
  /shared/postgres_data/base/16400/43448
  /shared/postgres_data/base/16400/43451
  /shared/postgres_data/base/16400/58203
  /shared/postgres_data/base/16400/44834
  /shared/postgres_data/base/16400/44837
  /shared/postgres_data/base/16400/44841
  /shared/postgres_data/base/16400/44843
  /shared/postgres_data/base/16400/44844
  /shared/postgres_data/base/16400/44846
  /shared/postgres_data/base/16400/44847
  /shared/postgres_data/base/16400/44848
  /shared/postgres_data/base/16400/45965
  /shared/postgres_data/base/16400/47387
  /shared/postgres_data/base/16400/47391
  /shared/postgres_data/base/16400/47393
  /shared/postgres_data/base/16400/47394
  /shared/postgres_data/base/16400/49275
  /shared/postgres_data/base/16400/49275_fsm
  /shared/postgres_data/base/16400/49284
  /shared/postgres_data/base/16400/49286
  /shared/postgres_data/base/16400/49287
  /shared/postgres_data/base/16400/49290
  /shared/postgres_data/base/16400/49291
  /shared/postgres_data/base/16400/49292
  /shared/postgres_data/base/16400/49295
  /shared/postgres_data/base/16400/49299
  /shared/postgres_data/base/16400/49301
  /shared/postgres_data/base/16400/49302
  /shared/postgres_data/base/16400/49304
  /shared/postgres_data/base/16400/49308
  /shared/postgres_data/base/16400/49312
  /shared/postgres_data/base/16400/49314
  /shared/postgres_data/base/16400/49315
  /shared/postgres_data/base/16400/49317
  /shared/postgres_data/base/16400/49318
  /shared/postgres_data/base/16400/56653
  /shared/postgres_data/base/16400/56659
  /shared/postgres_data/base/16400/56660
  /shared/postgres_data/base/16400/56661
  /shared/postgres_data/base/16400/49340
  /shared/postgres_data/base/16400/49342
  /shared/postgres_data/base/16400/49369
  /shared/postgres_data/base/16400/57430
  /shared/postgres_data/base/16400/49382
  /shared/postgres_data/base/16400/49383
  /shared/postgres_data/base/16400/49384
  /shared/postgres_data/base/16400/49385
  /shared/postgres_data/base/16400/49386
  /shared/postgres_data/base/16400/49392
  /shared/postgres_data/base/16400/49405
  /shared/postgres_data/base/16400/49406
  /shared/postgres_data/base/16400/49407
  /shared/postgres_data/base/16400/49408
  /shared/postgres_data/base/16400/50109
  /shared/postgres_data/base/16400/50111
  /shared/postgres_data/base/16400/50123
  /shared/postgres_data/base/16400/50124
  /shared/postgres_data/base/16400/50125
  /shared/postgres_data/base/16400/50126
  /shared/postgres_data/base/16400/52020
  /shared/postgres_data/base/16400/50128
  /shared/postgres_data/base/16400/50129
  /shared/postgres_data/base/16400/50130
  /shared/postgres_data/base/16400/57431
  /shared/postgres_data/base/16400/51940
  /shared/postgres_data/base/16400/51956
  /shared/postgres_data/base/16400/51957
  /shared/postgres_data/base/16400/51958
  /shared/postgres_data/base/16400/51959
  /shared/postgres_data/base/16400/51959_fsm
  /shared/postgres_data/base/16400/51960
  /shared/postgres_data/base/16400/51961
  /shared/postgres_data/base/16400/51962
  /shared/postgres_data/base/16400/51963
  /shared/postgres_data/base/16400/51966
  /shared/postgres_data/base/16400/51970
  /shared/postgres_data/base/16400/51972
  /shared/postgres_data/base/16400/51973
  /shared/postgres_data/base/16400/51974
  /shared/postgres_data/base/16400/51986
  /shared/postgres_data/base/16400/51996
  /shared/postgres_data/base/16400/52000
  /shared/postgres_data/base/16400/52002
  /shared/postgres_data/base/16400/52003
  /shared/postgres_data/base/16400/52008
  /shared/postgres_data/base/16400/52010
  /shared/postgres_data/base/16400/52016
  /shared/postgres_data/base/16400/52018
  /shared/postgres_data/base/16400/54081
  /shared/postgres_data/base/16400/54082
  /shared/postgres_data/base/16400/54087
  /shared/postgres_data/base/16400/54089
  /shared/postgres_data/base/16400/54094
  /shared/postgres_data/base/16400/54094_fsm
  /shared/postgres_data/base/16400/54094_vm
  /shared/postgres_data/base/16400/54098
  /shared/postgres_data/base/16400/54100
  /shared/postgres_data/base/16400/54101
  /shared/postgres_data/base/16400/55616
  /shared/postgres_data/base/16400/55631
  /shared/postgres_data/base/16400/55633
  /shared/postgres_data/base/16400/55639
  /shared/postgres_data/base/16400/55644
  /shared/postgres_data/base/16400/55646
  /shared/postgres_data/base/16400/56395
  /shared/postgres_data/base/16400/56401
  /shared/postgres_data/base/16400/56403
  /shared/postgres_data/base/16400/56404
  /shared/postgres_data/base/16400/56411
  /shared/postgres_data/base/16400/56412
  /shared/postgres_data/base/16400/56413
  /shared/postgres_data/base/16400/56414
  /shared/postgres_data/base/16400/56415
  /shared/postgres_data/base/16400/56416
  /shared/postgres_data/base/16400/56417
  /shared/postgres_data/base/16400/56656
  /shared/postgres_data/base/16400/56658
  /shared/postgres_data/base/16400/57432
  /shared/postgres_data/base/16400/57394
  /shared/postgres_data/base/16400/57398
  /shared/postgres_data/base/16400/57402
  /shared/postgres_data/base/16400/57406
  /shared/postgres_data/base/16400/57408
  /shared/postgres_data/base/16400/57409
  /shared/postgres_data/base/16400/57411
  /shared/postgres_data/base/16400/57412
  /shared/postgres_data/base/16400/57413
  /shared/postgres_data/base/16400/57414
  /shared/postgres_data/base/16400/57416
  /shared/postgres_data/base/16400/57417
  /shared/postgres_data/base/16400/57418
  /shared/postgres_data/base/16400/57423
  /shared/postgres_data/base/16400/57425
  /shared/postgres_data/base/16400/57433
  /shared/postgres_data/base/16400/57434
  /shared/postgres_data/base/16400/58194
  /shared/postgres_data/base/16400/58196
  /shared/postgres_data/base/16400/58204
  /shared/postgres_data/base/16400/58210
  /shared/postgres_data/base/16400/58211
  /shared/postgres_data/base/16400/58216
  /shared/postgres_data/base/16400/58218
  /shared/postgres_data/base/16400/58222
  /shared/postgres_data/base/16400/58605
  /shared/postgres_data/base/16400/58609
  /shared/postgres_data/base/16400/58611
  /shared/postgres_data/base/16400/58612
  /shared/postgres_data/base/16400/58629
  /shared/postgres_data/base/16400/58630
  /shared/postgres_data/base/16400/58631
  /shared/postgres_data/base/16400/58632
  /shared/postgres_data/base/16400/58633
  /shared/postgres_data/base/16400/58634
  /shared/postgres_data/base/16400/58635
  /shared/postgres_data/base/16400/58636
  /shared/postgres_data/base/16400/60535
  /shared/postgres_data/base/16400/60541
  /shared/postgres_data/base/16400/60542
  /shared/postgres_data/base/16400/60543
  /shared/postgres_data/base/16400/60544
  /shared/postgres_data/base/16400/60545
  /shared/postgres_data/base/13014/2613
  /shared/postgres_data/base/13014/2683
  /shared/postgres_data/base/1/2613
  /shared/postgres_data/base/1/2683
                                                            ok
Setting next OID for new cluster                            ok
Sync data directory to disk                                 ok
Creating script to analyze new cluster                      ok
Creating script to delete old cluster                       ok

Upgrade Complete
----------------
Optimizer statistics are not transferred by pg_upgrade so,
once you start the new server, consider running:
    ./analyze_new_cluster.sh

Running this script will delete the old cluster's data files:
    ./delete_old_cluster.sh
-------------------------------------------------------------------------------------
UPGRADE OF POSTGRES COMPLETE

Old 10 database is stored at /shared/postgres_data_old

To complete the upgrade, rebuild again using:

./launcher rebuild app
-------------------------------------------------------------------------------------

217185f8a096d87caa8a240cfc6e824e1f01ebc2f624df51b4bf88ebeb95a671
root@chat:/var/discourse#

결국 다시 다음 단계로 돌아오게 되었습니다:

업그레이드를 완료하려면 다음 명령을 사용하여 다시 빌드하세요:

./launcher rebuild app

루프에 갇혀버렸네요…

미리 감사드립니다.

8

app.yml 파일들을 공유해 주시겠어요? (비밀번호는 제거해 주세요.)

9

고맙습니다 @Falco

root@chat:/var/discourse# cat /var/discourse/containers/app.yml
##
## 이 파일에 변경 사항을 적용한 후, 라이브 Discourse 인스턴스에서
## 변경 사항이 반영되려면 반드시 재빌드(rebuild)해야 합니다:
##
## /var/discourse/launcher rebuild app
##
## YAML 문법을 준수하십시오! 다음 사이트를 사용하여 확인하는 데 도움이 됩니다:
## http://www.yamllint.com/

## 이것은 올인원(standalone) Discourse Docker 컨테이너 템플릿입니다

# web.ratelimited 템플릿의 주석을 해제하여 레이트 리미팅(rate limiting)을 추가할 수 있습니다.
# 기본적으로 IP당 초당 12개 요청, IP당 분당 100개 요청을 허용합니다.
# 이 파일의 매개변수를 수정하여 설정할 수 있습니다.

templates:
  - "templates/postgres.template.yml"
  - "templates/redis.template.yml"
  - "templates/web.template.yml"
  - "templates/web.ssl.template.yml"
  - "templates/web.letsencrypt.ssl.template.yml"
  - "templates/web.ratelimited.template.yml"

 ## Discourse 설치에 Lets Encrypt를 추가하려면 다음 줄들의 주석을 해제하십시오
 # - "templates/web.ssl.template.yml"
 # - "templates/web.letsencrypt.ssl.template.yml"

## 이 컨테이너가 노출할 TCP/IP 포트는 무엇입니까?
expose:
  - "80:80"   # 호스트 포트 80을 컨테이너 포트 80으로 전달 (http)
  - "443:443" # 호스트 포트 443을 컨테이너 포트 443으로 전달 (https) (ssl 준비 완료)
# Apache 또는 nginx와 같은 다른 웹서버와 Discourse가 포트를 공유하기를 원한다면,
# 설명은 https://meta.discourse.org/t/17247 를 참조하십시오.

# Docker를 위한 추가 인수가 있습니까?
# docker_args:

params:
  db_default_text_search_config: "pg_catalog.english"

  ## db_shared_buffers를 총 메모리의 최대 25%로 설정하십시오.
  ##
  ## 1GB 설치의 경우 128MB로 설정하십시오 (다른 프로세스를 위한 여유 공간 확보)
  ## 4GB 인스턴스의 경우 1GB로 높일 수 있습니다
  #db_shared_buffers: "256MB"
  #
  ## 큰 인스턴스에서는 더 높게 설정하십시오. 기본값은 10MB이며, 3GB 설치의 경우 40MB가 좋은 기본값입니다
  ## 이것은 정렬 성능을 향상시키지만, 연결당 메모리 사용량을 증가시킵니다
  #db_work_mem: "40MB"
  #
  ## 이 컨테이너는 어떤 Git 리비전을 사용해야 합니까? (기본값: tests-passed)
  #version: tests-passed

env:
  LANG: en_US.UTF-8
  # DISCOURSE_DEFAULT_LOCALE: en

  ## TODO: 동시 웹 요청은 몇 개까지 지원됩니까?
  ## 2GB의 경우 3-4개의 워커를, 1GB의 경우 2개만 권장합니다
  ## 메모리가 충분하다면, 논리 CPU 코어당 워커 1~2개를 사용하십시오
  #UNICORN_WORKERS: 3

  ## TODO: 초기 가입 시 관리자 및 개발자로 설정될 쉼표로 구분된 이메일 목록
  ## 예시 'user1@example.com,user2@example.com'
  DISCOURSE_DEVELOPER_EMAILS: 'XXX@commedia.org.uk'

  ## TODO: 이 Discourse 인스턴스가 응답할 도메인 이름
  DISCOURSE_HOSTNAME: 'chat.commedia.org.uk'
  ## TODO: 컨테이너가 위에서 지정된 도메인 이름과 동일한
  ##       도메인 이름(-h 옵션)으로 시작되도록 하려면 주석을 해제하십시오 (기본값 "$hostname-$config")
  ## 참고: 여기서 'true'만 유효한 값이며, 기타 값은 무시됩니다
  #DOCKER_USE_HOSTNAME: true

  ## TODO: 이 Discourse 인스턴스가 사용할 메일서버
  DISCOURSE_SMTP_ADDRESS: smtp.mailgun.org                   # (필수)
  # DISCOURSE_SMTP_PORT:                                     # (선택)
  DISCOURSE_SMTP_USER_NAME: postmaster@chat.commedia.org.uk  # (선택)
  DISCOURSE_SMTP_PASSWORD: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX  # (선택, 경고: 비밀번호의 '#' 문자는 문제를 일으킬 수 있음!)
  #DISCOURSE_SMTP_ENABLE_START_TLS: true                     # (선택, 기본값 true)

  ## Lets Encrypt 이메일은 Lets Encrypt 템플릿을 추가한 경우 무료 SSL 인증서를 등록할 수 있게 해줍니다. 설정을 완료했다면 주석을 해제하십시오
  LETSENCRYPT_ACCOUNT_EMAIL: XXX@commedia.org.uk

  ## 이 Discourse 인스턴스의 CDN 주소 (pull로 구성됨)
  #DISCOURSE_CDN_URL: //discourse-cdn.example.com

## 이러한 컨테이너는 상태가 없으며(stateless), 모든 데이터는 /shared에 저장됩니다
volumes:
  - volume:
      host: /var/discourse/shared/standalone
      guest: /shared
  - volume:
      host: /var/discourse/shared/standalone/log/var-log
      guest: /var/log

## docker manager 플러그인은 Discourse를 원클릭으로 업그레이드할 수 있게 해줍니다
## http://chat.canstream.co.uk/admin/docker
hooks:
  after_code:
    - exec:
        cd: $home/plugins
        cmd:
          - git clone https://github.com/discourse/docker_manager.git

## 기억하십시오, 이것은 YAML 문법입니다 - 이름이 있는 블록은 하나만 가질 수 있습니다
run:
  - exec: echo "Beginning of custom commands"

  ## 첫 번째 가입 시 'From' 이메일 주소를 설정하려면 주석을 해제하고 변경하십시오:
  #- exec: rails r "SiteSetting.notification_email='info@unconfigured.discourse.org'"
  ## 첫 번째 가입 이메일을 받은 후, 해당 줄에 다시 주석을 달아야 합니다. 한 번만 실행하면 됩니다.

  ## root의 비밀번호 로그인을 설정하려면 주석을 해제하고 변경하십시오:
  ## 다음 줄 중 하나만 사용하십시오:
  #- exec: /usr/sbin/usermod -p 'PASSWORD_HASH' root
  #- exec: /usr/sbin/usermod -p "$(mkpasswd -m sha-256 'RAW_PASSWORD')" root

  - exec: echo "End of custom commands"
root@chat:/var/discourse#

도움이 되기를 바랍니다.

10

다음 명령어의 출력은 무엇인가요?

ls -lah /var/discourse/shared/standalone/

du -sh /var/discourse/shared/standalone/postgres_data

du -sh /var/discourse/shared/standalone/postgres_data_new

cat /var/discourse/shared/standalone/postgres_data/PG_VERSION

cat /var/discourse/shared/standalone/postgres_data_new/PG_VERSION

11

@Falco 님 감사합니다.

진전이 있긴 한 것 같습니다. 타임아웃은 발생하지 않고 이제 “502 Bad Gateway” 오류가 나네요.

확인해본 명령어 결과입니다:

(1)

root@chat:~# ls -lah /var/discourse/shared/standalone/
total 60K
drwxr-xr-x 15 root     root       4.0K May 16 21:14 .
drwxr-xr-x  3 root     root       4.0K Apr 12  2016 ..
drwxr-xr-x  3 itcrowd  www-data   4.0K Jul  5  2016 backups
drwxr-xr-x  8 root     root       4.0K May  5 01:13 letsencrypt
drwxr-xr-x  4 root     root       4.0K Apr 12  2016 log
drwxr-xr-x  2 postfix  lpadmin    4.0K Apr 12  2016 postgres_backup
drwx------ 21 colord   landscape  4.0K May 16 21:14 postgres_data
drwx------ 19 colord   landscape  4.0K May 16 21:14 postgres_data_new
drwx------ 16      107 scanner    4.0K Aug 13  2018 postgres_data_old
drwxrwsr-x  6 colord   landscape  4.0K May 16 21:14 postgres_run
drwxr-xr-x  2      108 sambashare 4.0K May 16 16:32 redis_data
drwxr-xr-x  2 root     root       4.0K Oct  2  2019 ssl
drwxr-xr-x  4 root     root       4.0K Apr 12  2016 state
drwxr-xr-x  4 itcrowd  www-data   4.0K May 17 01:09 tmp
drwxr-xr-x  4 itcrowd  www-data   4.0K Jul  7  2016 uploads

(2)

root@chat:~# du -sh /var/discourse/shared/standalone/postgres_data
831M    /var/discourse/shared/standalone/postgres_data

(3)

root@chat:~# du -sh /var/discourse/shared/standalone/postgres_data_new/
391M    /var/discourse/shared/standalone/postgres_data_new/

(4)

root@chat:~# cat /var/discourse/shared/standalone/postgres_data/PG_VERSION 10

(5)

root@chat:~# cat /var/discourse/shared/standalone/postgres_data_new/PG_VERSION 12

현재 리스닝 중인 포트입니다:

root@chat:~# netstat -tulpn
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      1137/sshd
tcp        0      0 0.0.0.0:25              0.0.0.0:*               LISTEN      1305/master
tcp6       0      0 :::80                   :::*                    LISTEN      1522/docker-proxy
tcp6       0      0 :::25                   :::*                    LISTEN      1305/master
tcp6       0      0 :::443                  :::*                    LISTEN      1506/docker-proxy

도움이 되셨으면 좋겠습니다.

지금은 잠깐 자고 나서 생각해보겠습니다.

다시 한번 감사드리며, 내일 다시 말씀 나눌게요.

12

음. 흥미로운 상황이네요. 새로운 12 폴더가 있고, 정상적으로 작동하는 것으로 보입니다.

다음과 같이 시도해 보실 수 있나요?

cd /var/discourse
./launcher stop app
mv shared/standalone/postgres_data shared/standalone/postgres_data_old
mv shared/standalone/postgres_data_new shared/standalone/postgres_data
./launcher rebuild app
13

많은 도움 주셔서 감사합니다, @Falco 님.

요약 성공했습니다!

자, 시작하겠습니다.

root@chat:/var/discourse# ./launcher stop app
^[[3~WARNING: Docker version 17.05.0-ce deprecated, recommend upgrade to 17.06.2 or newer.
+ /usr/bin/docker stop -t 10 app
app
root@chat:/var/discourse# mv shared/standalone/postgres_data shared/standalone/postgres_data_old
mv: cannot move ‘shared/standalone/postgres_data’ to ‘shared/standalone/postgres_data_old/postgres_data’: Directory not empty

좋습니다, postgres_data_old을 다른 곳으로 이동시키고 계속 진행하겠습니다:

root@chat:/var/discourse# mv shared/standalone/postgres_data_old shared/standalone/postgres_data_old_170520
root@chat:/var/discourse# mv shared/standalone/postgres_data shared/standalone/postgres_data_old
root@chat:/var/discourse# mv shared/standalone/postgres_data_new shared/standalone/postgres_data

root@chat:/var/discourse# ./launcher rebuild app

좋습니다, 재빌드 과정이 매우 길었습니다. 여기 로그 일부를 복사/붙여넣기할 수 있지만, stdout 버퍼 용량을 초과할 정도로 데이터가 많아 전체를 기록하지는 못했습니다. 나중에 도움이 될지 모르겠지만요.

하지만 성공했습니다 - 정말로, 정말로 감사합니다!

다음과 같이 말씀하셨습니다:

새로운 12 폴더가 있고, 그것이 정상적으로 작동하는 것으로 보입니다.

12 폴더는 볼 수 있습니다 - 그런데 그것이 정상적으로 작동한다는 것을 어떻게 아셨나요?

cat /var/discourse/shared/standalone/postgres_data_new/PG_VERSION 12

그리고 문제의 본질은 무엇이었나요 - 새 데이터베이스가 인식되지 않았던 것인가요?

어쨌든, 지금은 작동합니다. 제가 무엇을 배웠는지는 확실하지 않지만, 이런 일이 다시 발생하면 참고하기 위해 이 페이지를 기록해 두겠습니다. 정말 무서운 일이었습니다!

다시 한번 감사드리며, 좋은 하루 보내시길 바랍니다 :clinking_glasses:

14

Postgres 12를 포함하여 2.5.0beta5로 성공적으로 업그레이드했습니다. 그런데 ./analyze_new_cluster.sh는 어디에 있으며, 왜 실행해야 하는 건가요?

15

해당 메시지는 pg_upgrade 바이너리에서 출력되는 것이며, 안전하게 무시할 수 있습니다.

이 메시지를 억제할 수 있는 옵션은 없는 것 같습니다.