Cuidado: processo de backup e restauração do banco de dados ao testar coisas

Suporte
1

I’m about to test a process of importing a boatload of content, but want to make sure I can revert properly in case things go sideways on me.

I run an external PostgreSQL instance, so my thought is that I don’t really need to backup the Discourse Rails instance in Docker, but simply the database via the following steps:

BACKUP:

  1. ./launcher stop app
  2. pg_dump -U username -p 12345 -W -F p databasename | xz > ~/backup/database/$(date +"%d-%m-%Y_%H.%M.%S").databasename.pgsql.xz
  3. ./launcher start app
  4. ### IMPORT CONTENT ###

If things went badly, RESTORE:

  1. ./launcher stop app
  2. xzcat ~/backup/database/DATE.databasename.pgsql.xz | psql -U username -p 12345 -W databasename
  3. ./launcher start app

And things should be back to sane and functional… correct?

2

Probably, there is a built in easy to restore that’s tested, supported, and requires just a couple of clicks or a single command line.

If your way doesn’t work you’re on your own.

1 curtida
3

As I noted, this is for an external PGSQL database since I’m not using the Dockerized one and sadly the normal backup/restore method just doesn’t work for me (probably because I’m running a little bit newer version of PGSQL on the big DB server).

4

Oh. Yeah. If you’re running pg11 then you’re on your own. If you’re running pg10 on an external db it should be fine.

But test it and see if it works.

1 curtida
5

PG11 and PG12 will be supported quite soon in the backup & restore process. Stay tuned.

4 curtidas
7

Olá. Eles já são suportados?

8

Eles são! A atualização foi há alguns meses.

2 curtidas
9

Obrigado! Apenas para esclarecer: restaurar um backup em um site Discourse (com conteúdo) deletaria completamente todos os dados da instância externa do banco de dados PostgreSQL (RDS)? Se a restauração falhar ou houver uma desconexão, os dados do RDS ficariam corrompidos?

10

Ele excluirá todos os dados do banco de dados do Discourse, mas não os demais. Se a restauração falhar, os dados existentes permanecerão.

2 curtidas