Atualizado para a versão mais recente: ./analyze_new_cluster.sh mensagem

Suporte Instalação
1

Olá

Hoje fiz a atualização do meu Discourse da seguinte forma:

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

Em seguida, obtive esta saída:

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
----------------
As estatísticas do otimizador não são transferidas pelo pg_upgrade, então,
assim que iniciar o novo servidor, considere executar:
    ./analyze_new_cluster.sh

Executar este script apagará os arquivos de dados do cluster antigo:
    ./delete_old_cluster.sh
-------------------------------------------------------------------------------------
ATUALIZAÇÃO DO POSTGRES CONCLUÍDA

O banco de dados antigo 10 está armazenado em /shared/postgres_data_old

Para concluir a atualização, reconstrua novamente usando:

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

Claro, quando tento executar ./analyze_new_cluster.sh, ele não existe:

./analyze_new_cluster.sh
-su: ./analyze_new_cluster.sh: Arquivo ou diretório não encontrado

Agora o Discourse não está carregando.

Parece ser um problema com a atualização do PostgreSQL, mas não quero mexer muito para não estragar as coisas.

O que pode ser feito? Obrigado antecipadamente.

2

Execute novamente ./launcher rebuild app como sugerido. Isso trará seu site de volta online.

Consulte o anúncio para mais informações.

4

O Discourse não carregará até que você siga as instruções para

5

Olá @Falco @itsbhanusharma

Tentei isso várias vezes, mas não funciona: https://chat.commedia.org.uk

Tenho espaço suficiente:

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

Obtenho uma série de saídas como esta:

Sucesso. Agora você pode iniciar o servidor de banco de dados usando:

    pg_ctlcluster 10 main start

Aviso: O diretório stats_temp_directory selecionado /var/run/postgresql/10-main.pg_stat_tmp
não é gravável para o proprietário do cluster. Esta configuração não será adicionada em
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: aviso: forçando a reinstalação da alternativa /usr/share/postgresql/12/man/man1/postmaster.1.gz porque o grupo de links postmaster.1.gz está quebrado
invoke-rc.d: não foi possível determinar o nível de execução atual
invoke-rc.d: policy-rc.d negou a execução de start.
Processando gatilhos para postgresql-common (213.pgdg100+1) ...
Construindo dicionários PostgreSQL a partir dos pacotes myspell/hunspell instalados...
Removendo arquivos de dicionário obsoletos:
Parando servidor de banco de dados PostgreSQL 10: main.
Parando servidor de banco de dados PostgreSQL 12: main.
Executando verificações de consistência

Então, tento iniciar o servidor de banco de dados conforme sugerido:

root@chat:/var/discourse# pg_ctlcluster 10 main start
O programa 'pg_ctlcluster' não está instalado atualmente. Você pode instalá-lo digitando:
apt-get install postgresql-common

Infelizmente, não sei nada sobre Postgres - parece-me que o Postgres não está em execução:

root@chat:/var/discourse# netstat -tulpn
Conexões ativas da Internet (apenas servidores)
Proto Recv-Q Send-Q Endereço Local          Endereço Remoto         Estado       PID/Programa
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

Portanto, preciso iniciar o Postgres.

Como isso pode ser feito?

Muito obrigado antecipadamente.

6

Sua reconstrução foi concluída com sucesso?

7

Olá @itsbhanusharma - obrigado.

Estou preso em um loop. Vou postar o log completo - é longo…

root@chat:/var/discourse# ./launcher rebuild app
WARNING: A versão do Docker 17.05.0-ce está obsoleta, recomenda-se a atualização para a 17.06.2 ou superior.
Garantindo que o launcher esteja atualizado
Buscando origin
O launcher está atualizado
Parando o container antigo
+ /usr/bin/docker stop -t 60 app
app
cd /pups && git pull && /pups/bin/pups --stdin
Já está atualizado.
I, [2020-05-16T20:14:12.296784 #1]  INFO -- : Carregando --stdin
I, [2020-05-16T20:14:12.306278 #1]  INFO -- : > locale-gen $LANG && update-locale
I, [2020-05-16T20:14:12.361144 #1]  INFO -- : Gerando localidades (isso pode demorar um pouco)...
Geração concluída.

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 já está em execução, pare o container ; exit 1
2020/05/16 20:14:12 socat[25] E connect(6, AF=1 "/shared/postgres_run/.s.PGSQL.5432", 36): Arquivo ou diretório não encontrado
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 -- : Arquivo > /etc/service/postgres/run  chmod: +x  chown:
I, [2020-05-16T20:14:12.427152 #1]  INFO -- : Arquivo > /etc/service/postgres/log/run  chmod: +x  chown:
I, [2020-05-16T20:14:12.435570 #1]  INFO -- : Arquivo > /etc/runit/3.d/99-postgres  chmod: +x  chown:
I, [2020-05-16T20:14:12.443806 #1]  INFO -- : Arquivo > /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: aviso: habilitando autenticação "trust" para conexões locais
Você pode alterar isso editando o pg_hba.conf ou usando a opção -A, ou
--auth-local e --auth-host, na próxima vez que executar o initdb.
debconf: adiando configuração de pacotes, pois apt-utils não está instalado
mv: não foi possível mover '/shared/postgres_data' para '/shared/postgres_data_old/postgres_data': Diretório não está vazio
mv: não foi possível mover '/shared/postgres_data_new' para '/shared/postgres_data/postgres_data_new': Diretório não está vazio
I, [2020-05-16T20:14:34.359859 #1]  INFO -- : Atualizando PostgreSQL da versão 10 para 12
Os arquivos pertencentes a este sistema de banco de dados serão de propriedade do usuário "postgres".
Este usuário também deve ser o proprietário do processo do servidor.

O cluster de banco de dados será inicializado com a localidade "en_US.UTF-8".
A codificação padrão do banco de dados foi definida como "UTF8".
A configuração padrão de pesquisa de texto será definida como "english".

Verificações de integridade de páginas de dados estão desativadas.

corrigindo permissões no diretório existente /shared/postgres_data_new ... ok
criando subdiretórios ... ok
selecionando implementação de memória compartilhada dinâmica ... posix
selecionando max_connections padrão ... 100
selecionando shared_buffers padrão ... 128MB
selecionando fuso horário padrão ... Etc/UTC
criando arquivos de configuração ... ok
executando script de inicialização ... ok
realizando inicialização pós-inicialização ... ok
sincronizando dados no disco ... ok


Sucesso. Agora você pode iniciar o servidor de banco de dados usando:

    /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)
Lendo listas de pacotes...
Lendo listas de pacotes...
Construindo árvore de dependências...
Lendo informações de estado...
Os seguintes pacotes adicionais serão instalados:
  postgresql-client-10
Pacotes sugeridos:
  postgresql-doc-10
Os seguintes NOVOS pacotes serão instalados:
  postgresql-10 postgresql-client-10
0 atualizados, 2 novos instalados, 0 a remover e 9 não atualizados.
É necessário obter 6.390 kB de arquivos.
Após esta operação, 30,6 MB de espaço em disco adicional serão utilizados.
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)
Selecionando o pacote postgresql-client-10, que não estava selecionado anteriormente.
(Lendo banco de dados ... 43929 arquivos e diretórios instalados atualmente.)
Preparando para descompactar .../postgresql-client-10_10.13-1.pgdg100+1_amd64.deb ...
Descompactando postgresql-client-10 (10.13-1.pgdg100+1) ...
Selecionando o pacote postgresql-10, que não estava selecionado anteriormente.
Preparando para descompactar .../postgresql-10_10.13-1.pgdg100+1_amd64.deb ...
Descompactando postgresql-10 (10.13-1.pgdg100+1) ...
Configurando postgresql-client-10 (10.13-1.pgdg100+1) ...
update-alternatives: aviso: forçando reinstalação da alternativa /usr/share/postgresql/12/man/man1/psql.1.gz porque o grupo de links psql.1.gz está quebrado
Configurando postgresql-10 (10.13-1.pgdg100+1) ...
Criando novo cluster PostgreSQL 10/main ...
/usr/lib/postgresql/10/bin/initdb -D /var/lib/postgresql/10/main --auth-local peer --auth-host md5
Os arquivos pertencentes a este sistema de banco de dados serão de propriedade do usuário "postgres".
Este usuário também deve ser o proprietário do processo do servidor.

O cluster de banco de dados será inicializado com a localidade "C.UTF-8".
A codificação padrão do banco de dados foi definida como "UTF8".
A configuração padrão de pesquisa de texto será definida como "english".

Verificações de integridade de páginas de dados estão desativadas.

corrigindo permissões no diretório existente /var/lib/postgresql/10/main ... ok
criando subdiretórios ... ok
selecionando max_connections padrão ... 100
selecionando shared_buffers padrão ... 128MB
selecionando fuso horário padrão ... Etc/UTC
selecionando implementação de memória compartilhada dinâmica ... posix
criando arquivos de configuração ... ok
executando script de inicialização ... ok
realizando inicialização pós-inicialização ... ok
sincronizando dados no disco ... ok

Sucesso. Agora você pode iniciar o servidor de banco de dados usando:

    pg_ctlcluster 10 main start

Aviso: O stats_temp_directory selecionado /var/run/postgresql/10-main.pg_stat_tmp
não é gravável para o proprietário do cluster. Não adicionando esta configuração em
postgresql.conf.
Ver Cluster Porta Status Proprietário Diretório de dados Arquivo de log
10 main 5433 parado postgres /var/lib/postgresql/10/main /var/log/postgresql/postgresql-10-main.log
update-alternatives: aviso: forçando reinstalação da alternativa /usr/share/postgresql/12/man/man1/postmaster.1.gz porque o grupo de links postmaster.1.gz está quebrado
invoke-rc.d: não foi possível determinar o nível de execução atual
invoke-rc.d: policy-rc.d negou a execução de start.
Processando gatilhos para postgresql-common (213.pgdg100+1) ...
Construindo dicionários PostgreSQL a partir de pacotes myspell/hunspell instalados...
Removendo arquivos de dicionário obsoletos:
Parando servidor de banco de dados PostgreSQL 10: main.
Parando servidor de banco de dados PostgreSQL 12: main.
Executando verificações de consistência
-----------------------------
Verificando versões do cluster ok
Verificando se o usuário do banco de dados é o usuário de instalação ok
Verificando configurações de conexão do banco de dados ok
Verificando transações preparadas ok
Verificando tipos de dados reg* em tabelas de usuário ok
Verificando contrib/isn com incompatibilidade de passagem de bigint ok
Verificando tabelas WITH OIDS ok
Verificando colunas de usuário "sql_identifier" inválidas ok
Criando dump de objetos globais ok
Criando dump de esquemas de banco de dados
  discourse
  postgres
  template1
                                                            ok
Verificando presença de bibliotecas necessárias ok
Verificando se o usuário do banco de dados é o usuário de instalação ok
Verificando transações preparadas ok

Se o pg_upgrade falhar após este ponto, você deve re-executar initdb no
novo cluster antes de continuar.

Executando atualização
------------------
Analisando todas as linhas no novo cluster                       ok
Congelando todas as linhas no novo cluster                        ok
Excluindo arquivos do novo pg_xact                             ok
Copiando pg_xact antigo para o novo servidor                           ok
Definindo próximo ID de transação e época para o novo cluster       ok
Excluindo arquivos do novo pg_multixact/offsets                ok
Copiando pg_multixact/offsets antigo para o novo servidor              ok
Excluindo arquivos do novo pg_multixact/members                ok
Copiando pg_multixact/members antigo para o novo servidor              ok
Definindo próximo ID de multixact e deslocamento para o novo cluster        ok
Resetando arquivos WAL                                      ok
Definindo contadores frozenxid e minmxid no novo cluster       ok
Restaurando objetos globais no novo cluster                 ok
Restaurando esquemas de banco de dados no novo cluster
  template1
  discourse
  postgres
                                                            ok
Copiando arquivos de relação de usuário
  /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
Definindo próximo OID para o novo cluster                            ok
Sincronizando diretório de dados no disco                                 ok
Criando script para analisar o novo cluster                      ok
Criando script para excluir o cluster antigo                       ok

Upgrade Concluído
----------------
As estatísticas do otimizador não são transferidas pelo pg_upgrade, portanto,
assim que você iniciar o novo servidor, considere executar:
    ./analyze_new_cluster.sh

A execução deste script excluirá os arquivos de dados do cluster antigo:
    ./delete_old_cluster.sh
-------------------------------------------------------------------------------------
UPGRADE DO POSTGRES CONCLUÍDO

O banco de dados antigo 10 está armazenado em /shared/postgres_data_old

Para concluir o upgrade, reconstrua novamente usando:

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

217185f8a096d87caa8a240cfc6e824e1f01ebc2f624df51b4bf88ebeb95a671
root@chat:/var/discourse#

Então, acabo voltando para:

Para concluir o upgrade, reconstrua novamente usando:

./launcher rebuild app

Estou preso em um loop…

Muito obrigado desde já.

8

Você poderia compartilhar seus arquivos app.yml? (Remova as senhas).

9

Obrigado @Falco

root@chat:/var/discourse# cat /var/discourse/containers/app.yml
##
## Após fazer alterações neste arquivo, você DEVE reconstruir para que qualquer
## alteração tenha efeito na sua instância Discourse em produção:
##
## /var/discourse/launcher rebuild app
##
## Certifique-se de obedecer à sintaxe YAML! Você pode usar este site para ajudar a verificar:
## http://www.yamllint.com/

## este é o modelo de contêiner Docker Discourse tudo-em-um, autônomo

# Você pode adicionar limitação de taxa descomentando o template web.ratelimited.
# Por padrão, ele permite 12 requisições por segundo por IP e 100 por minuto por IP
# Isso é configurável ao alterar os parâmetros neste arquivo

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"

 ## Comente as linhas a seguir se desejar adicionar o Lets Encrypt para sua instalação do Discourse
 # - "templates/web.ssl.template.yml"
 # - "templates/web.letsencrypt.ssl.template.yml"

## quais portas TCP/IP este contêiner deve expor?
expose:
  - "80:80"   # encaminha porta do host 80   para porta do contêiner 80 (http)
  - "443:443" # encaminha porta do host 443   para porta do contêiner 443 (https) (pronto para SSL)
# Se você quiser que o Discourse compartilhe uma porta com outro servidor web como Apache ou nginx,
# consulte https://meta.discourse.org/t/17247 para instruções.

# algum argumento extra para o Docker?
# docker_args:

params:
  db_default_text_search_config: "pg_catalog.english"

  ## Defina db_shared_buffers para no máximo 25% da memória total.
  ##
  ## Em instalações de 1GB, defina como 128MB (para deixar espaço para outros processos)
  ## em uma instância de 4GB você pode aumentar para 1GB
  #db_shared_buffers: "256MB"
  #
  ## Defina mais alto em instâncias grandes; o padrão é 10MB, para uma instalação de 3GB 40MB é um bom padrão
  ## isso melhora o desempenho de ordenação, mas aumenta o uso de memória por conexão
  #db_work_mem: "40MB"
  #
  ## Qual revisão do Git este contêiner deve usar? (padrão: tests-passed)
  #version: tests-passed

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

  ## TODO: Quantas requisições web simultâneas são suportadas?
  ## Com 2GB recomendamos 3-4 workers, com 1GB apenas 2
  ## Se você tiver muita memória, use um ou dois workers por núcleo lógico da CPU
  #UNICORN_WORKERS: 3

  ## TODO: Lista de e-mails separados por vírgula que serão feitos administradores e desenvolvedores
  ## no exemplo de cadastro inicial 'user1@example.com,user2@example.com'
  DISCOURSE_DEVELOPER_EMAILS: 'XXX@commedia.org.uk'

  ## TODO: O nome de domínio ao qual esta instância do Discourse responderá
  DISCOURSE_HOSTNAME: 'chat.commedia.org.uk'
  ## TODO: Descomente se quiser que o contêiner seja iniciado com o mesmo
  ##       nome de host (opção -h) especificado acima (padrão "$hostname-$config")
  ## OBSERVAÇÃO: 'true' é o único valor válido aqui; qualquer outro será ignorado
  #DOCKER_USE_HOSTNAME: true

  ## TODO: O servidor de e-mail que esta instância do Discourse usará
  DISCOURSE_SMTP_ADDRESS: smtp.mailgun.org                   # (obrigatório)
  # DISCOURSE_SMTP_PORT:                                     # (opcional)
  DISCOURSE_SMTP_USER_NAME: postmaster@chat.commedia.org.uk  # (opcional)
  DISCOURSE_SMTP_PASSWORD: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX  # (opcional, AVISO: o caractere '#' na senha pode causar problemas!)
  #DISCOURSE_SMTP_ENABLE_START_TLS: true                     # (opcional, padrão true)

  ## O e-mail do Lets Encrypt permitirá que você registre um certificado SSL GRATUITO se adicionou o template Lets Encrypt; comente se já configurou isso
  LETSENCRYPT_ACCOUNT_EMAIL: XXX@commedia.org.uk

  ## O endereço do CDN para esta instância do Discourse (configurado para buscar)
  #DISCOURSE_CDN_URL: //discourse-cdn.example.com

## Estes contêineres são sem estado; todos os dados são armazenados em /shared
volumes:
  - volume:
      host: /var/discourse/shared/standalone
      guest: /shared
  - volume:
      host: /var/discourse/shared/standalone/log/var-log
      guest: /var/log

## O plugin docker manager permite que você atualize o Discourse com um clique
## http://chat.canstream.co.uk/admin/docker
hooks:
  after_code:
    - exec:
        cd: $home/plugins
        cmd:
          - git clone https://github.com/discourse/docker_manager.git

## Lembre-se, esta é sintaxe YAML — você só pode ter um bloco com um nome
run:
  - exec: echo "Início dos comandos personalizados"

  ## Se quiser definir o endereço de e-mail 'De' para seu primeiro cadastro, descomente e altere:
  #- exec: rails r "SiteSetting.notification_email='info@unconfigured.discourse.org'"
  ## Após receber o primeiro e-mail de cadastro, recomente a linha. Ela só precisa ser executada uma vez.

  ## Se quiser configurar login por senha para root, descomente e altere:
  ## Use apenas uma das linhas a seguir:
  #- exec: /usr/sbin/usermod -p 'PASSWORD_HASH' root
  #- exec: /usr/sbin/usermod -p "$(mkpasswd -m sha-256 'RAW_PASSWORD')" root

  - exec: echo "Fim dos comandos personalizados"
root@chat:/var/discourse#

Espero que isso ajude.

10

Qual é a saída de

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

Obrigado, @Falco.

Talvez haja progresso: não está mais dando timeout e agora recebo um erro “502 Bad Gateway”

Ok, comandos:

(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

Aqui está o que está ouvindo:

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

Espero que isso ajude.

Por enquanto, vou precisar dormir sobre o assunto.

Muito obrigado novamente e falamos amanhã.

12

Hmm. Situação interessante. Você tem uma nova pasta 12, e isso parece estar funcionando bem.

Pode tentar:

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

Muito obrigado @Falco.

TL;DR Funcionou!

Ok, vamos lá.

root@chat:/var/discourse# ./launcher stop app
^[[3~AVISO: A versão do Docker 17.05.0-ce está obsoleta, recomenda-se atualizar para a 17.06.2 ou mais recente.
+ /usr/bin/docker stop -t 10 app
app
root@chat:/var/discourse# mv shared/standalone/postgres_data shared/standalone/postgres_data_old
mv: não foi possível mover 'shared/standalone/postgres_data' para 'shared/standalone/postgres_data_old/postgres_data': Diretório não vazio

Ok, vou mover postgres_data_old para o lado e continuar:

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, houve um processo de reconstrução muito longo. Posso copiar e colar parte do log aqui se isso ajudar pessoas futuras, mas não capturei tudo, pois havia muitos dados para o buffer de stdout.

Mas funcionou — muito, muito obrigado!

Você disse:

Você tem uma nova pasta 12, e parece que está funcionando bem.

Consigo ver a pasta 12, mas como você soube que estava funcionando corretamente?

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

E qual foi a essência do problema — que o novo banco de dados não havia sido detectado?

De qualquer forma, funciona. Não tenho certeza do que aprendi, mas vou guardar uma anotação desta página para usar caso isso aconteça novamente. Coisas assustadoras!

Obrigado novamente e tudo de bom por enquanto :clinking_glasses:

14

Atualizei com sucesso para a versão 2.5.0beta5, incluindo o Postgres 12. Mas onde está ./analyze_new_cluster.sh e por que devo executá-lo?

15

Essa mensagem vem do binário pg_upgrade e você pode ignorá-la com segurança.

Parece que não há uma opção para suprimi-la.