谨慎行事：测试时的数据库备份与恢复流程

支持
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 个赞
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 个赞
5

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

4 个赞
7

你好，现在支持它们了吗？

8

是的！升级是在几个月前进行的。

2 个赞
9

谢谢！ clarification 一下，将备份恢复到 Discourse 站点（包含内容）是否会完全删除外部 PostgreSQL 数据库实例（RDS）中的所有数据？如果恢复失败或连接中断，RDS 中的数据是否会损坏？

10

它将删除 Discourse 数据库中的所有数据，但不会影响其他数据。如果恢复失败，现有数据将保持不变。

2 个赞