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?

./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

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

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.

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

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

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.

You can follow my way to restore website backup. backup the website files and app.yml. download them on top of your Windows reinstall the vps system, debian or Ubuntu is recommended install Docker prerequisites (based on Debian/Ubuntu distro example) sudo apt install docker.io sudo apt install git Install Discourse sudo -s git clone https://github.com/discourse/discourse_docker.git /var/discourse cd /var/discourse chmod 700 containers 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 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

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.

Error trying to restore my forum

Product Support Self-hosting

pfaffman (Jay Pfaffman) August 3, 2024, 8:14pm 2

How big is your database?

How much ram do you have?

This is a standard install?

Topic		Replies	Views
Encountered an error while restoring from a backup Self-hosting backups	11	627	May 12, 2024
Can't restore from backup Self-hosting	12	2538	January 16, 2018
Can't restore saved backup Self-hosting	3	1386	March 7, 2017
Backup failed due to PG/SQL errors Self-hosting	9	2558	December 17, 2020
Discourse Bad Gateway after reboot Self-hosting	15	2402	July 2, 2020

Error trying to restore my forum

Related topics