Migration from Maketplace AMI #7065
Unanswered
salinger66666
asked this question in
Help / Questions
Replies: 1 comment
-
As a supplement, when pg_dump is executed with the -v option, it seems that the backup of the "public.assetData" table takes a very long time and does not finish. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I am operating a server on AWS using the Wiki.js image from Marketplace.
https://docs.requarks.io/install/aws
https://aws.amazon.com/marketplace/pp/prodview-xx5w3vp7mmwwy
Since support for Ubuntu 18.04 LTS has ended, I am trying to migrate to a new server running Ubuntu 22.04 and Docker Compose by referring to the document below.
https://docs.requarks.io/install/docker
https://docs.requarks.io/install/transfer
However, when I run the command in the document below,
docker exec db pg_dump wiki -U wiki -F c > wikibackup.dump
The following error was displayed and pg_dump could not be executed.
pg_dump: Error message from server: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
Enabling statement_timeout = 0 in postgresql.conf in the db container resolved the above error, but the dump did not finish even after several hours.
The current findings are that there are no problems with the memory, CPU, or disk IO in the server, but is there any solution?
Beta Was this translation helpful? Give feedback.
All reactions