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?
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?
./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
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.
sudo apt install docker.io
sudo apt install git
sudo -s
git clone https://github.com/discourse/discourse_docker.git /var/discourse
cd /var/discourse
chmod 700 containers
. /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. 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.
We’re glad I could help you
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.