Error in restoring database from Backup #16955
Unanswered
abhishekrukhaiyar
asked this question in
Q&A
Replies: 1 comment 2 replies
-
|
Can anyone help with this? |
Beta Was this translation helpful? Give feedback.
2 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Hi,
I accidentallly deleted the database by recreating postgres container. I found the issue which recreated the database and fixed it.
Now, I'm trying to restore the database from the backup. I copied the recent backup file to the same folder as docker compose. I'm running following command
And, Getting the following error.
gunzip < "18mar.sql.gz" \ | sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g" \ | sudo docker exec -i immich_postgres psql -U postgres -d immichAny solution you can suggest.
sed: can't read : No such file or directorygzip: .gz: No such file or directoryThanks in advance.
Beta Was this translation helpful? Give feedback.
All reactions