Error trying to restore my forum

Product Support Self-hosting

AI-generated summary

David_Ghost is trying to restore their Discourse forum from DigitalOcean to Lightsail but encounters a PostgreSQL error related to memory allocation (maintenance_work_mem is too low). pfaffman suggests increasing the setting in the PostgreSQL config file. sheng_hualuo provides a detailed step-by-step guide for restoring the forum using the command line, including backing up files, reinstalling Discourse, and using launcher commands to rebuild and restore. David_Ghost confirms that after adjusting the maintenance_work_mem setting in the PostgreSQL configuration file and restarting the app, the restoration succeeded. David_Ghost thanks both users for their help.

1

Hello, I’m trying to restore my forum from DO to lightsail. Everything went well, but when I try to restore, this error message appears:

[2024-08-03 19:46:08] ERROR: memory required is 77 MB, maintenance_work_mem is 64 MB
[2024-08-03 19:46:08] EXCEPTION: psql failed: ERROR: memory required is 77 MB, maintenance_work_mem is 64 MB

how i can fix that, please?

2

How big is your database?

How much ram do you have?

This is a standard install?

3

80mb for my database.
16 GB RAM for the vps
and yes it’s a standard install

4

Strange.

What I would do is enter the container, install vim, edit the postgres config file to increase the setting it complains about (restart with “sv restart postgres”) and restore from the command line.

5

i can’t find this file. You know where i can find it?

6

Did you execute this command when you reinstalled discourse./discourse-setup?

7

./launcher enter app
Path: /etc/postgresql/13/main/postgresql.conf
The 13 in the path is the version number, and our version may not be the same. Go to the /etc/postgresql folder to view it

8

Yes, and it recognized my RAM automatically.

I even tried to do a new clean installation, but now it gives an error before it finishes uploading.

It seems that nothing works. I have also tried to restore with rsync.

I will try to restore later by command line when i understand better how to send my backup by command line. For now, im getting a “permission denied (publickey)”. But its not discourse problem.

9

You can follow my way to restore website backup.

  1. backup the website files and app.yml. download them on top of your Windows
  2. reinstall the vps system, debian or Ubuntu is recommended
  3. install Docker prerequisites (based on Debian/Ubuntu distro example)
sudo apt install docker.io
sudo apt install git
  1. Install Discourse
sudo -s
git clone https://github.com/discourse/discourse_docker.git /var/discourse
cd /var/discourse
chmod 700 containers
  1. Edit the discourse configuration (emphasis added)
. /discourse-setup

After executing the command you will be prompted to enter the domain name, you need to use ctrl+c to cancel the operation because you backed up app.yml
6. Enter the discourse configuration folder

1. cd /var/discourse/containers/ #enter configuration folder
2. rm app.yml #delete the configuration file created by default
3. upload your backup app.yml to this folder
4. cd ... # fallback to the discourse folder
5. . /launcher rebuild app # rebuild discourse
  1. After rebuilding the discourse, start the restoration process
1. mkdir /var/discourse/shared/standalone/backups/default/ #Create a folder for backup files.
2. cd /var/discourse/shared/standalone/backups/default/ #Go to the folder and upload your site's backup files in this folder.
3. cd /var/discourse/ #Go back to the discourse folder.
4. . /launcher enter app #Enter the discourse container
5. discourse enable_restore #Enable discourse restore function
6. discourse restore your-site-backup.tar.gz # Start restoring the backup by replacing your-site-backup.tar.gz with the name of your site backup file
10

the path is correct i found the line for edit. I put 80mb limit + a restart app and it was worked very well. Im very happy. Thank you very much Sheng and @pfaffman.

11

We’re glad I could help you