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

Ciao @itsbhanusharma - grazie.

Sono in un loop. Posterò l’intero log - è lungo…

root@chat:/var/discourse# ./launcher rebuild app
WARNING: Docker version 17.05.0-ce deprecated, recommend upgrade to 17.06.2 or newer.
Verifica che il launcher sia aggiornato
Recupero dell'origine
Il launcher è aggiornato
Arresto del vecchio container
+ /usr/bin/docker stop -t 60 app
app
cd /pups && git pull && /pups/bin/pups --stdin
Già aggiornato.
I, [2020-05-16T20:14:12.296784 #1]  INFO -- : Caricamento da --stdin
I, [2020-05-16T20:14:12.306278 #1]  INFO -- : > locale-gen $LANG && update-locale
I, [2020-05-16T20:14:12.361144 #1]  INFO -- : Generazione delle impostazioni locali (questo potrebbe richiedere un po' di tempo)...
Generazione completata.

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: abilitazione dell'autenticazione "trust" per le connessioni locali
È possibile modificare questa impostazione editando pg_hba.conf o utilizzando l'opzione -A, o
--auth-local e --auth-host, la prossima volta che si esegue initdb.
debconf: ritardo della configurazione del pacchetto, poiché apt-utils non è installato
mv: impossibile spostare '/shared/postgres_data' in '/shared/postgres_data_old/postgres_data': Directory not empty
mv: impossibile spostare '/shared/postgres_data_new' in '/shared/postgres_data/postgres_data_new': Directory not empty
I, [2020-05-16T20:14:34.359859 #1]  INFO -- : Aggiornamento di PostgreSQL dalla versione 10 alla 12
I file appartenenti a questo sistema di database saranno di proprietà dell'utente "postgres".
Questo utente deve essere anche proprietario del processo server.

Il cluster di database verrà inizializzato con le impostazioni locali "en_US.UTF-8".
Di conseguenza, la codifica predefinita del database è stata impostata su "UTF8".
La configurazione predefinita della ricerca testuale verrà impostata su "english".

I checksum delle pagine di dati sono disabilitati.

correzione dei permessi sulla directory esistente /shared/postgres_data_new ... ok
creazione delle sottodirectory ... ok
selezione dell'implementazione della memoria condivisa dinamica ... posix
selezione del valore predefinito per max_connections ... 100
selezione del valore predefinito per shared_buffers ... 128MB
selezione del fuso orario predefinito ... Etc/UTC
creazione dei file di configurazione ... ok
esecuzione dello script di bootstrap ... ok
esecuzione dell'inizializzazione post-bootstrap ... ok
sincronizzazione dei dati sul disco ... ok


Operazione completata con successo. Ora è possibile avviare il server di database utilizzando:

    /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)
Lettura degli elenchi dei pacchetti...
Lettura degli elenchi dei pacchetti...
Costruzione dell'albero delle dipendenze...
Lettura delle informazioni di stato...
I seguenti pacchetti aggiuntivi verranno installati:
  postgresql-client-10
Pacchetti suggeriti:
  postgresql-doc-10
I seguenti pacchetti NUOVI verranno installati:
  postgresql-10 postgresql-client-10
0 aggiornati, 2 installati per la prima volta, 0 da rimuovere e 9 non aggiornati.
È necessario scaricare 6.390 kB di archivi.
Dopo questa operazione, verranno utilizzati 30,6 MB di spazio su disco aggiuntivo.
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)
Selezione del pacchetto postgresql-client-10, precedentemente non selezionato.
(Lettura del database ... 43929 file e directory attualmente installati.)
Preparazione dello sblocco di .../postgresql-client-10_10.13-1.pgdg100+1_amd64.deb ...
Sblocco di postgresql-client-10 (10.13-1.pgdg100+1) ...
Selezione del pacchetto postgresql-10, precedentemente non selezionato.
Preparazione dello sblocco di .../postgresql-10_10.13-1.pgdg100+1_amd64.deb ...
Sblocco di postgresql-10 (10.13-1.pgdg100+1) ...
Configurazione di postgresql-client-10 (10.13-1.pgdg100+1) ...
update-alternatives: warning: forzatura della reinstallazione dell'alternativa /usr/share/postgresql/12/man/man1/psql.1.gz perché il gruppo di link psql.1.gz è danneggiato
Configurazione di postgresql-10 (10.13-1.pgdg100+1) ...
Creazione di un nuovo cluster PostgreSQL 10/main ...
/usr/lib/postgresql/10/bin/initdb -D /var/lib/postgresql/10/main --auth-local peer --auth-host md5
I file appartenenti a questo sistema di database saranno di proprietà dell'utente "postgres".
Questo utente deve essere anche proprietario del processo server.

Il cluster di database verrà inizializzato con le impostazioni locali "C.UTF-8".
Di conseguenza, la codifica predefinita del database è stata impostata su "UTF8".
La configurazione predefinita della ricerca testuale verrà impostata su "english".

I checksum delle pagine di dati sono disabilitati.

correzione dei permessi sulla directory esistente /var/lib/postgresql/10/main ... ok
creazione delle sottodirectory ... ok
selezione del valore predefinito per max_connections ... 100
selezione del valore predefinito per shared_buffers ... 128MB
selezione del fuso orario predefinito ... Etc/UTC
selezione dell'implementazione della memoria condivisa dinamica ... posix
creazione dei file di configurazione ... ok
esecuzione dello script di bootstrap ... ok
esecuzione dell'inizializzazione post-bootstrap ... ok
sincronizzazione dei dati sul disco ... ok

Operazione completata con successo. Ora è possibile avviare il server di database utilizzando:

    pg_ctlcluster 10 main start

Warning: La directory stats_temp_directory selezionata /var/run/postgresql/10-main.pg_stat_tmp
non è scrivibile per il proprietario del cluster. Non viene aggiunta questa impostazione in
postgresql.conf.
Ver Cluster Porta Stato Proprietario Directory dati File log
10 main 5433 down postgres /var/lib/postgresql/10/main /var/log/postgresql/postgresql-10-main.log
update-alternatives: warning: forzatura della reinstallazione dell'alternativa /usr/share/postgresql/12/man/man1/postmaster.1.gz perché il gruppo di link postmaster.1.gz è danneggiato
invoke-rc.d: impossibile determinare il livello di esecuzione corrente
invoke-rc.d: policy-rc.d ha negato l'esecuzione di start.
Elaborazione dei trigger per postgresql-common (213.pgdg100+1) ...
Costruzione dei dizionari PostgreSQL dai pacchetti myspell/hunspell installati...
Rimozione dei file di dizionario obsoleti:
Arresto del server di database PostgreSQL 10: main.
Arresto del server di database PostgreSQL 12: main.
Esecuzione dei controlli di coerenza
-----------------------------
Controllo delle versioni del cluster                                   ok
Controllo che l'utente del database sia l'utente di installazione      ok
Controllo delle impostazioni di connessione al database                ok
Controllo delle transazioni preparate                                  ok
Controllo dei tipi di dati reg* nelle tabelle utente                   ok
Controllo di contrib/isn con mismatch bigint-passing                   ok
Controllo delle tabelle WITH OIDS                                      ok
Controllo delle colonne utente "sql_identifier" non valide             ok
Creazione del dump degli oggetti globali                               ok
Creazione del dump degli schemi del database
  discourse
  postgres
  template1
                                                            ok
Controllo della presenza delle librerie richieste                      ok
Controllo che l'utente del database sia l'utente di installazione      ok
Controllo delle transazioni preparate                                  ok

Se pg_upgrade fallisce dopo questo punto, è necessario eseguire re-initdb sul
nuovo cluster prima di continuare.

Esecuzione dell'aggiornamento
------------------
Analisi di tutte le righe nel nuovo cluster                       ok
Congelamento di tutte le righe nel nuovo cluster                  ok
Eliminazione dei file dal nuovo pg_xact                          ok
Copia del vecchio pg_xact sul nuovo server                       ok
Impostazione del prossimo ID transazione e dell'epoca per il nuovo cluster  ok
Eliminazione dei file dal nuovo pg_multixact/offsets             ok
Copia del vecchio pg_multixact/offsets sul nuovo server          ok
Eliminazione dei file dal nuovo pg_multixact/members             ok
Copia del vecchio pg_multixact/members sul nuovo server          ok
Impostazione del prossimo ID multixact e dell'offset per il nuovo cluster  ok
Reset degli archivi WAL                                          ok
Impostazione dei contatori frozenxid e minmxid nel nuovo cluster ok
Ripristino degli oggetti globali nel nuovo cluster               ok
Ripristino degli schemi dei database nel nuovo cluster
  template1
  discourse
  postgres
                                                            ok
Copia dei file delle relazioni utente
  /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
Impostazione del prossimo OID per il nuovo cluster                            ok
Sincronizzazione della directory dati su disco                                 ok
Creazione dello script per analizzare il nuovo cluster                      ok
Creazione dello script per eliminare il vecchio cluster                       ok

Aggiornamento Completato
----------------
Le statistiche dell'ottimizzatore non vengono trasferite da pg_upgrade, quindi,
una volta avviato il nuovo server, considera di eseguire:
    ./analyze_new_cluster.sh

L'esecuzione di questo script eliminerà i file di dati del vecchio cluster:
    ./delete_old_cluster.sh
-------------------------------------------------------------------------------------
AGGIORNAMENTO DI POSTGRES COMPLETATO

Il vecchio database 10 è memorizzato in /shared/postgres_data_old

Per completare l'aggiornamento, ricostruisci nuovamente usando:

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

217185f8a096d87caa8a240cfc6e824e1f01ebc2f624df51b4bf88ebeb95a671
root@chat:/var/discourse#

Quindi, torno semplicemente al punto:

Per completare l'aggiornamento, ricostruisci nuovamente usando:

./launcher rebuild app

Sono bloccato in un ciclo…

Grazie mille in anticipo.

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.