Aggiornato all'ultima versione: ./analyze_new_cluster.sh messaggio

Supporto Installazione
1

Ciao

Oggi ho aggiornato il mio Discourse come segue:

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

Ho ottenuto quindi questo output:

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

Per completare l'aggiornamento, esegui nuovamente la ricompilazione con:

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

Ovviamente, quando provo a eseguire ./analyze_new_cluster.sh, il file non esiste:

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

Ora Discourse non si carica.

Sembra un problema legato all’aggiornamento di PostgreSQL, ma non voglio fare troppe modifiche per non rovinare tutto.

Cosa si può fare? Grazie in anticipo.

2

Esegui di nuovo ./launcher rebuild app come suggerito. Questo riporterà il tuo sito online.

Consulta l’annuncio per ulteriori informazioni.

4

Discourse non si caricherà finché non segui le istruzioni per

5

Ciao @Falco @itsbhanusharma

Ho provato più volte ma non funziona: https://chat.commedia.org.uk

Ho spazio sufficiente:

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

Ricevo un sacco di output come questo:

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

Quindi provo ad avviare il server del database come suggerito:

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

Purtroppo non so nulla di Postgres; sembra che Postgres non sia in esecuzione:

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

Quindi devo avviare Postgres.

Come si potrebbe fare?

Grazie mille in anticipo.

6

Il rebuild è terminato con successo?

7

Hi @itsbhanusharma - thanks.

I’m in a loop. I’ll post the whole log - it’s long…

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.

Performing Upgrade
------------------
Analyzing all rows in the new cluster                       ok
Freezing all rows in the new cluster                        ok
Deleting files from new pg_xact                             ok
Copying old pg_xact to new server                           ok
Setting next transaction ID and epoch for new cluster       ok
Deleting files from new pg_multixact/offsets                ok
Copying old pg_multixact/offsets to new server              ok
Deleting files from new pg_multixact/members                ok
Copying old pg_multixact/members to new server              ok
Setting next multixact ID and offset for new cluster        ok
Resetting WAL archives                                      ok
Setting frozenxid and minmxid counters in new cluster       ok
Restoring global objects in the new cluster                 ok
Restoring database schemas in the new cluster
  template1
  discourse
  postgres
                                                            ok
Copying user relation files
  /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#

So, I just come back round to:

To complete the upgrade, rebuild again using:

./launcher rebuild app

I’m stuck in a loop…

Mnay thanks in advance.

8

Puoi condividere i tuoi file app.yml? (Rimuovi le password).

9

Grazie @Falco

root@chat:/var/discourse# cat /var/discourse/containers/app.yml
##
## Dopo aver apportato modifiche a questo file, DEVI eseguire il rebuild affinché
## le modifiche abbiano effetto sulla tua istanza Discourse in produzione:
##
## /var/discourse/launcher rebuild app
##
## Assicurati di rispettare la sintassi YAML! Puoi usare questo sito per verificare:
## http://www.yamllint.com/

## questo è il modello del container Docker Discourse all-in-one, standalone

# Puoi aggiungere il rate limiting decommentando il template web.ratelimited.
# Di default consente 12 richieste al secondo per IP e 100 al minuto per IP
# È configurabile modificando i parametri in questo file

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"

 ## Commenta le righe seguenti se desideri aggiungere Let's Encrypt per la tua installazione Discourse
 # - "templates/web.ssl.template.yml"
 # - "templates/web.letsencrypt.ssl.template.yml"

## quali porte TCP/IP dovrebbe esporre questo container?
expose:
  - "80:80"   # inoltra la porta host 80 alla porta container 80 (http)
  - "443:443" # inoltra la porta host 443 alla porta container 443 (https) (pronto per SSL)
# Se vuoi che Discourse condivida una porta con un altro server web come Apache o nginx,
# consulta https://meta.discourse.org/t/17247 per le istruzioni.

# eventuali argomenti aggiuntivi per Docker?
# docker_args:

params:
  db_default_text_search_config: "pg_catalog.english"

  ## Imposta db_shared_buffers a un massimo del 25% della memoria totale.
  ##
  ## Su installazioni da 1GB impostalo a 128MB (per lasciare spazio ad altri processi)
  ## su un'istanza da 4GB puoi aumentarlo a 1GB
  #db_shared_buffers: "256MB"
  #
  ## Imposta più alto su istanze grandi; di default è 10MB, per un'installazione da 3GB 40MB è un buon valore predefinito
  ## questo migliora le prestazioni di ordinamento, ma aumenta l'uso di memoria per connessione
  #db_work_mem: "40MB"
  #
  ## Quale revisione Git dovrebbe usare questo container? (default: tests-passed)
  #version: tests-passed

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

  ## TODO: Quante richieste web concorrenti sono supportate?
  ## Con 2GB consigliamo 3-4 worker, con 1GB solo 2
  ## Se hai molta memoria, usa uno o due worker per core CPU logico
  #UNICORN_WORKERS: 3

  ## TODO: Elenco di email separate da virgola che saranno rese amministratori e sviluppatori
  ## all'iscrizione iniziale, esempio 'user1@example.com,user2@example.com'
  DISCOURSE_DEVELOPER_EMAILS: 'XXX@commedia.org.uk'

  ## TODO: Il nome di dominio a cui risponderà questa istanza Discourse
  DISCOURSE_HOSTNAME: 'chat.commedia.org.uk'
  ## TODO: Decommenta se vuoi che il container venga avviato con lo stesso
  ##       hostname (opzione -h) specificato sopra (default "$hostname-$config")
  ## NOTA: 'true' è l'unico valore valido qui; qualsiasi altro verrà ignorato
  #DOCKER_USE_HOSTNAME: true

  ## TODO: Il server di posta che questa istanza Discourse utilizzerà
  DISCOURSE_SMTP_ADDRESS: smtp.mailgun.org                   # (obbligatorio)
  # DISCOURSE_SMTP_PORT:                                     # (opzionale)
  DISCOURSE_SMTP_USER_NAME: postmaster@chat.commedia.org.uk  # (opzionale)
  DISCOURSE_SMTP_PASSWORD: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX  # (opzionale, ATTENZIONE: il carattere '#' nella password può causare problemi!)
  #DISCOURSE_SMTP_ENABLE_START_TLS: true                     # (opzionale, default true)

  ## L'email di Let's Encrypt ti permette di registrare un certificato SSL GRATUITO se hai aggiunto il template Let's Encrypt; decommentalo se hai già configurato tutto
  LETSENCRYPT_ACCOUNT_EMAIL: XXX@commedia.org.uk

  ## L'indirizzo CDN per questa istanza Discourse (configurato per il pull)
  #DISCOURSE_CDN_URL: //discourse-cdn.example.com

## Questi container sono stateless; tutti i dati sono memorizzati in /shared
volumes:
  - volume:
      host: /var/discourse/shared/standalone
      guest: /shared
  - volume:
      host: /var/discourse/shared/standalone/log/var-log
      guest: /var/log

## Il plugin docker manager ti permette di aggiornare Discourse con un clic
## http://chat.canstream.co.uk/admin/docker
hooks:
  after_code:
    - exec:
        cd: $home/plugins
        cmd:
          - git clone https://github.com/discourse/docker_manager.git

## Ricorda, questa è sintassi YAML: puoi avere solo un blocco con un nome
run:
  - exec: echo "Inizio dei comandi personalizzati"

  ## Se vuoi impostare l'indirizzo email 'From' per la tua prima registrazione, decommenta e modifica:
  #- exec: rails r "SiteSetting.notification_email='info@unconfigured.discourse.org'"
  ## Dopo aver ricevuto la prima email di iscrizione, rimetti il commento alla riga. Deve essere eseguita una sola volta.

  ## Se vuoi configurare l'accesso con password per root, decommenta e modifica:
  ## Usa solo una delle seguenti righe:
  #- exec: /usr/sbin/usermod -p 'PASSWORD_HASH' root
  #- exec: /usr/sbin/usermod -p "$(mkpasswd -m sha-256 'RAW_PASSWORD')" root

  - exec: echo "Fine dei comandi personalizzati"
root@chat:/var/discourse#

Spero ti sia utile.

10

Qual è l’output di

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

Grazie @Falco.

Forse ci siamo: non va più in timeout e ora ottengo un errore “502 Bad Gateway”

Ok, comandi:

(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

Ecco cosa sta ascoltando:

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

Spero che questo aiuti.

Per ora devo lasciar riposare la cosa.

Grazie ancora e ci sentiamo domani.

12

Hmm. Situazione interessante. Hai una nuova cartella 12 e sembra funzionare correttamente.

Puoi provare a:

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

Molte grazie @Falco.

TL;DR Ha funzionato!

Ok, eccoci.

root@chat:/var/discourse# ./launcher stop app
^[[3~AVVISO: La versione Docker 17.05.0-ce è deprecata, si consiglia l'aggiornamento alla 17.06.2 o superiore.
+ /usr/bin/docker stop -t 10 app
app
root@chat:/var/discourse# mv shared/standalone/postgres_data shared/standalone/postgres_data_old
mv: impossibile spostare 'shared/standalone/postgres_data' in 'shared/standalone/postgres_data_old/postgres_data': Directory non vuota

Ok, sposto postgres_data_old fuori strada e continuo:

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

Ok, c’è stato un processo di ricostruzione molto lungo. Potrei copiare/incollare parte del registro qui se aiutasse le persone future, ma non l’ho catturato tutto perché c’erano troppi dati per il buffer stdout.

Ma ha funzionato - molte, molte grazie!

Hai detto:

Hai una nuova cartella 12, e sembra che funzioni bene.

Vedo la cartella 12, ma come hai saputo che funzionava correttamente?

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

E qual era l’essenza del problema: che il nuovo database non era stato rilevato?

Comunque, funziona. Non sono sicuro di cosa abbia imparato, ma terrò nota di questa pagina da usare se ciò dovesse accadere di nuovo. Roba spaventosa!

Grazie ancora e tanti auguri per ora :clinking_glasses:

14

Ho aggiornato con successo alla versione 2.5.0beta5, incluso Postgres 12. Ma dove si trova ./analyze_new_cluster.sh e perché dovrei eseguirlo?

15

Quel messaggio proviene dall’eseguibile pg_upgrade e può essere ignorato in sicurezza.

Sembra che non esista un’opzione per disattivarlo.